Forum Discussion
Solved
How to subtract the difference between 2 cells that contain DD:MM:YYYY HH:MM?
Hi Need help please.
What formula do do to get the difference between 2 DD:MM:YYYY HH:MM in HH:MM.
For instance - I tried simply subtracting the cells but I get this:
| 26/09/2022 13:09 | 28/09/2022 13:23 | 00:14 |
The answer should be 48:14 and my formula does not seem to take into account there is 2 days worth of time to calculate as well as the 14 minutes.
Any suggestions please?
Thanks!
The number format is hh:mm, not [hh]:mm as I suggested.
If you change the number format to the custom format [hh]:mm, you'll see the correct duration:
Workbook attached.
7 Replies
Set the number format of the cell with the difference to the custom format [hh]:mm
The [ ] around hh instruct Excel to display the time as duration instead of as clock time.
- This has not made any difference. It is still showing as 00:14 where as it should be 48:14. Anyone got anymore suggestions please?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
