Although Excel can't display negative times, the undelying value is still
correct, so you can include them in calculations like SUM().
To display them, you would need a separate cell like

=IF(C10,TEXT(C1,"hh:mm:ss"),"-"&TEXT(ABS(C1),"hh:mm:ss"))

Of course that is text, so only for display, not for calculation

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bernard Liengme" wrote in message
...
Babs,
Excel does not let you have negative time (or date) value
Some help may be obtained from
http://j-walk.com/ss/excel/usertips/tip051.htm
http://exceltip.com/st/Negative_time...Excel/525.html
http://www.techonthenet.com/excel/qu...time_calcs.php
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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