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