Negative times are displayed a ###########
This is because it is running over midnight.
Try
=MOD(A2-B2,1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Omar" wrote in message
ups.com...
Dear Experts,
How can I get the real figure if I have the following message?
Negative times are displayed a ###########.
Actually I got the above massage from the below formula.
=2:49 - 3:17, (hh:mm format)
Thanks.
|