Solved subtracting date/time, over 24hrs

January 28, 2014 at 14:34:34
Specs: Windows 7
cell a1 is 1/7/14 13:35
cell b1 is 1/9/14 20:30

attempting to get total ellapsed time in hh:mm. simple b1-a1 does not account days past

See More: subtracting date/time, over 24hrs

Report •

January 28, 2014 at 17:23:00
✔ Best Answer
You need to Custom Format your answer cell as [H]:MM:SS

Right Click the cell
Select Format Cells
Under Categories, select Custom
Scroll down till you find the format of [h]:mm:ss
Select it and click OK

The brackets around the hour are required.


message edited by mmcconaghy

Report •

January 29, 2014 at 03:45:20
wow, you dont know how many times i have tried that formating h:mm;@ and it never worked.
your format suggestion works like a charm. thanks

Report •

Related Solutions

Ask Question