Hi

Then maybe the number of hours will do.
=(cell1-cell2)*24
and format as number

Arvi Laanemets


"WMA" wrote in message
...
Arvi Laanemets skrev:
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)



Yes, it is negativ, if you work to long f.ex. the company ows you some
time, if you work to short you ow time to company, I've got plenty of
these datas.

W