You should be able to just subtract the begin time from the ending time, but
you may need to enter the date along with the time (to accomodate shifts that
span different days).

For example:
A B C
1 7/31/05 6:00 7/31/05 18:00 =B1-A1



"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?