Forum Discussion
Solved
Difference datetime fields over 24hours
I am trying to subtract two excel date/time fields from each other to determine the difference. the fields are in the format 04/08/2018 23:30 08/08/2018 10:25 I can take ColB away fro...
Hi JM_381
it depends on how you would like to see the results. Generally, a normal subtraction works in any case, no matter if there is a 24h gap.
So you probably want to use custom number format [h]:mm
Kind regards,
Martin
Hi JM_381
it depends on how you would like to see the results. Generally, a normal subtraction works in any case, no matter if there is a 24h gap.
So you probably want to use custom number format [h]:mm
Kind regards,
Martin
Thanks Martin
It was the number format that was throwing me. I went with [h]:mm and it worked perfectly.
J
It was the number format that was throwing me. I went with [h]:mm and it worked perfectly.
J