New Contributor
15/12/20 11:3425/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 Replies
best response confirmed by itsDhruv (New Contributor)


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).

Thanks man!! you are a saver