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
--
Regards
Roger Govier
"Jed" wrote in message
...
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
"Brento" wrote
in
message ...
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
--
Brento
------------------------------------------------------------------------
Brento's Profile:
http://www.excelforum.com/member.php...o&userid=25213
View this thread:
http://www.excelforum.com/showthread...hreadid=500549