=MOD(End_Time - Start_Time,1)

so if B2 holds end time and A2 start time

=MOD(B2-A2,1)

if you total the hours later use custom format as in [hh]:mm or else the
display will start over again after 24 hours

--
Regards,

Peo Sjoblom

(No private emails please)


"cheryl" wrote in message
...
I have a stop and start time in two side by side cells. I need the hrs
worked in the next cell but the variouse functions I have tried havn't
worked. I usually get 0:00.
I'm using the custom formatting hh:mm. I have two twelve hours shifts,
24/7. My results look like this: Start -----
Stop ------
Total hrs worked
(day shift) 6:00 AM 6:00 PM 0:00
(night shift) 6:00 PM 6:00 AM 0:00
(occasional odd ones) 8:00 PM 2:00 AM 0:00

The start/stop entries are be entered in military time (18:00 = 6:00 PM).
I
need the total hrs worked to calculate automatically. Can someone please
help?