Hi

Must the result really be negative, or there is a midnight rollover? I.e
something started at evening, and ended on next morning. When this is the
case, use the formula
=cell1 - cell2 + (cell1<cell2)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"WMA" wrote in message
...
Hi!

How can I get to show the negative value of time data in my cells (t.ex.
cell1 - cell2 < 0) and then I've got ###### insted of digits.

W