time formula
Here is another one:
=MOD(B1-A1,1)
Not sure what you want to show if one or both of the cells is blank
=if(countblank(A1:B1)0,"",MOD(B1-A1,1))
--
Regards,
Tom Ogilvy
"crusty53" wrote in message
...
i have problems getting correct time.
A B C
1 16:00 00:30
2 15:43 23:49
3 13:55 00:01
In column C i want the time between A & B. But it keeps giving me 15:30
and it should be 8:30 Can anybody help.
The formula i am using is (B1-A1)
A is sign on time
B is sign off time
|