The only way to display negative times is to switch to the 1904 date system.
However, this will change every date in your spreadsheet by 4 years and 1
day, so for most people it's impractical.

Excel will do all the calculations, it just won't *display* negative times.
An alternative, therefore, may be to display decimal hours rather than
times. To do this, multiply your result by 24, and format as a number (or
general).

Is this something you can work with?

Regards,
Fred.

"Babs" wrote in message
...
Hi everyone,
first time on here so hope you can help me.

I use Excel (2003) for recording employee time / flexi hours. This is
allowed to go into a negative but I can't seem to display this. The
formula
calculates fine and when the time is positive is shown in the time format
(ie
15:30 etc) but when it is negative I just get #### which usually means
the
column needs widening but this doesn't make any difference.
Any ideas anyone?
Thanks

--
Babs - Leicester UK