Hi Cheryl
As Peo told you in his response, your total cell need to be custom formatted
to [hh]:mm to allow a rollover past 24 hours

--
Regards

Roger Govier


"cheryl" wrote in message
...
Thanks so much. Now each persons hours are calculating correctly. But
now
the crews total hours are not adding up correctly at the bottom of the
column. Does anyone know why or how to format or fix this cell?

"Govind" wrote:

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?