Time difference
 

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

Time difference
 

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

Time difference
 

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