Example:

Start Time Ending Time Hours
8:00 1:00 17
9:00 16:00 7
10:00 13:00 3
11:00 12:00 1

and in hours this formula: =HOUR(IF(B21<A21,B21+24-A21,B21-A21)) the cell
format to number.

--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"Jeff" wrote:

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