Thanks, Niek, for putting me straight. I do not work much with time and have
always assumed the #### was an error rather than just a message "I cannot
show you that"
best wishes
--
Bernard

"Niek Otten" wrote in message
...
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