Percentage increase in excel for cell in hour format

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

hour_excel

Ale

Posted 2019-09-26T08:39:41.620

Reputation: 704

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

Answers

2

This method solves the issue:

enter image description here

How it works:

  • Applied Time format on cell L37 and M39:M41 is mm:ss.

  • Formula in Cell M39, fill down till required.

    IF(ISBLANK(K39),"",(L$37*K39)+L$37)

Adjust cell reference in formula as needed,

Rajesh S

Posted 2019-09-26T08:39:41.620

Reputation: 6 800

Glad to help you @Ale ,, keep asking ☺ – Rajesh S – 2019-09-26T09:55:46.330

Asked: 2019-09-26T08:39:41.620

Viewed: 41 times

Active: 2019-09-26T09:37:37.197