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...
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.
I'm afraid that doesn't help. I repeat the request from my previous reply.
HansVogelaar I attach, formula is in there as you can see,but as mentioned above this formula is not taking into account when there is a difference in date as well as time. Please note the format is for Date is United Kingdom. Thank you.
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.