Hi,

Use

=IF(B1<A1,B1+1-A1,B1-A1)

where B1 is the stop time and A1 is the start time.Format the result in
hour format.

Regards

Govind.

cheryl wrote:

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?