hi. My question is also similar. We work shifts round-the-clock here,
and I need to keep track of hours worked per shift (some are 12, 10, 8, ...).
Through experimentation, I have managed this:

=IF(C5D5,(ABS(C5))-(ABS(D5)),D5-C5). with C5 as the start time, and D5 the
end time.

It works fine, except when some one starts at 10PM, and gets off at
8AM. It shows 14 hours worked when it should be 10.
Also, I would like to enter the times as 2200 instead of 22:00. Is
that possible?
When I do it with out the colon, I usually get 12AM and a strange date.


"Roze" wrote:

Hi guys... I have a similiar query.... plzzzz can someone help me!

I'm constructing a spreadsheet to work out the difference in time and date;
A1 A2 A3
07/11/04 11:00 04/11/04 10:00 3:1:00 (d:h:mm)
but now i'm trying to work out a fomula that if it goes over one day the
formula would work out true/false... i've tried doing the following but it
doesn't work;

=IF(A3=1,"Failed","Met") but it doesn't work...... doesn't seem to
register the day

Thank you