| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to calculate hours?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate hours on work sheet | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
| calculate average hours worked | Excel Worksheet Functions | |||
Threaded Mode
