It is still a correct value even if it doesn't show as such, so any further
calculations using that value will be correct.

If it is just to see it correctly, you could force it like so

=IF(B1-A1<0,"-","")&TEXT(ABS(B1-A1),"hh:mm:SS")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"james" wrote in message
...
I am trying to set up a spreadsheet to record staff flex-time. Formating
to
record time produces errors when negative are introduced.