Hi all,
As it says above really; I am looking for a way to subtract date time stamps and show the result in hh:mm:ss.
COLUMN A COLUMN B COLUMN C
01/01/2016 10:10:53 05/01/2016 11:49:25 =B1-B2
In C1 I get 01:38:32.
C1 is formatted to show hh:mm:ss -- so it is doing the calculation right.
If I change the format of the cell to dd/mm/yyyy hh:mm:ss; the result in C1 is now 04/01/1990 01:38:32
So, how do I make it perform the deduction and show 97:38:32 ??
I have tried converting to days, subtracting and *24 then adding to time; but (1) its ugly and messy & (2) it falls down at the end of a calendar month/year and gets even uglier and messier.
Any help greatly appreciated
Cheers
Andy
Bookmarks