Subtracting times

  • Thread starter Thread starter Dasco
  • Start date Start date
D

Dasco

I need to subtract one time from another. When the result is a positive, I
get the correct answer. However when the time is negative e.g. 37:50-40:00,
the result is #####

Any ideas?
Thanks - Dave
 
I need to subtract one time from another. When the result is a positive, I
get the correct answer. However when the time is negative e.g. 37:50-40:00,
the result is #####

Any ideas?
Thanks - Dave
Click to expand...

To display a negative time you need to switch to the 1904 date system:
tools>option > calculation tab> check 1904 date system


Hope this helps
 
=MOD(time2-time1,1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for that - worked perfectly. Dave

Bob Phillips said:
=MOD(time2-time1,1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...
 
Back
Top