| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring 24 Hours Per Day
I am laying out a time sheet that has shop time, travel time, on site time,
break time, and travel time back to shop. I have this formula: =(IF(C8="","",(E8-D8)+(G8-F8)+(M8-L8)+(I8-H8)-(K8-J8))) It works great if you work during the day time, but if you work past midnight it won't figure the hours in I8 (start time) and H8 (end time). Can someone please help me out? Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Late night Hours | Excel Discussion (Misc queries) | |||
| Figuring out hours worked | Excel Discussion (Misc queries) | |||
| Figuring cost based on hours | Excel Discussion (Misc queries) | |||
| Figuring hours | Excel Worksheet Functions | |||
| Figuring hours | Excel Worksheet Functions | |||
Threaded Mode
