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 we want to add time for 9 days, how one can do it ?
can someone help?
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).
2 Replies
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
