excel(date-time)

[itsDhruv]

15/12/20 11:34

25/12/20 8:00

it will give 9.8512963 on calculating the difference and when we format it in time, it will give 20:25:52.

hence it only includes time for 0.8512963, but if we want to add time for 9 days, how one can do it ?

can someone help?

[#2 · Accepted solution]

@itsDhruv 

Apply the custom number format [h]:mm:ss to the cell with the difference.

The square brackets [ ] around the h make Excel display cumulative hours (which can be greater than or equal to 24) instead of clock hours (which can only be 0 ... 23).

[#3]

Thanks man!! you are a saver