2
I need to set a formula to calculate a percentage increase/decrease from a cell with hour format.
Now the original cell is like [mm:ss] and I need that the result to be also in tha same format.
By now I converted the original cell into seconds (numbers), increased the necessary percentage and divided the result cell by 86400. I would like to know if there was a way to avoid the intermediate step
Check the image below
2Please share some sample data (screen shot) along with formula you have tried so far,, help us to understand the issue to fix it !! – Rajesh S – 2019-09-26T08:52:54.743
1I would like to know if there was a way to avoid the intermediate step Remove, what a problem? The value looks like a time is a number formatted as time. It can be multiplied directly, and the result must be formatted as time too. – Akina – 2019-09-26T09:23:14.160
You are right, sorry for the stupid question. You can close it :-( – Ale – 2019-09-26T09:26:45.373
@Ale,, check my post it skips the time to convert into Numeric seconds & directly get the increment & decremented changes in Time Format. – Rajesh S – 2019-09-26T09:48:08.120