You could go into tools=options, calculation tab and change to the 1904 date
system (the default for the mac). This supports negative dates, but your
dates would be off by about 4 years.

or you could use a formula like

=if(A1b1,"-"&Text(a1-b1,"hh:mm"),Text(b1-a1,"hh:mm"))

--
Regards,
Tom Ogilvy


"Jelinek" wrote:

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