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