Subtracting Time using mm:ss.00 format
Miasha,
=A1-B1 is subtracting the larger from the smaller, meaning the results will
be negative. EL can't handle negative times. That is why you are getting
the #####. Reverse the cell references and you calculation should work
correctly: =B1-A1
A1 = 03:24.65 = 3 mins, 24 secs, 65 ms. As far as XL is concerned about
time, 12 midnight is 0, high noon is 0.5....so 03:14.65 would round to
12:03:15.
A2 = 05:12:55 = 5 hrs, 12 mins, 55 secs.
HTH,
Conan
"Miasha" wrote in message
...
I need to subtract the difference between two different times. For
example:
1) In Cell A1 I have typed 03:24.65
2) In Cell B1, I have typed 05:12:55
I formatted the cells as: mm:ss.00.
My formula in C1 is =A1-B1. It returns all pound signs (#######).
Additionally, when you click in the enter field for cell A1 it displays
12:03:25 AM instead of what I typed in A1 which was 03:24.65. I must have
cell C1 display the exact difference. Can anyone tell me the best
function
or IF statement to use to calculate this? Thanks in advance.
|