Time difference

B

Brento

Hi All,

I am trying to display the difference in time in a minus state but all
i get is ######, eg 36:00:00 - 48:00:00 = -12:00:00 but what i get is
#######, please can any one help.

thanks
Brent
 
J

Jed

To get negative time, use 1904 date system.
Select Tools, Options, click on calculation tab & put a tick in 1904 date
system.
Hope this helps.

Jed
 
R

Roger Govier

Hi

Note that this will throw any other dates you have entered on the sheet
already, out by 4 years and 1 day because of the difference in the base
reference date.
If this is a problem for you, stick with 1900 date system but use
=MOD(A1-B1,1)
where A1 = 36:00:00 and B1 holds 48:00:00
 
Top