View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.