Forum Discussion
Solved
excel(date-time)
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 w...
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).
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