You can do this by setting the date system to the 1904 reference.
Go to the Tools menu, choose Options, then the Calculation tab.
Check "1904 date system". Note, though, that this will cause all
existing dates to be 4 years off.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jelinek" wrote in message
...
i have two columns of data both time formats when i subtract one
from the
other it displays ###### if it is a minus value is there away
to get round
this i would like to view the diffrence even if it is a minus
amount.

Thanks

Simon