maybe this will help

=MOD(B1-A1,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DazedandConfused" wrote in
message ...
I have a cell in whic the formula may return a positive time or negative
time
depending on the hours worked.
I can format the cell to display a positive time or a negative time but
not
to switch between the 2.
I have tried formatting the cell to h:mm;(h:mm) and using the 1904 date
system but neither work
HELP!!!!!