I have created a time sheet for employees (Attached) but the sum of the hours starts over after exceeding 24 hours. How can correct this formula?
Column B is time in and column C is time out. Column D is daily hours worked "D2 =C2-B2". These columns are formatted for time in 24hr format.
The formula I am using for my weekly total is D11 =Sum(D2:D8).
I would also like to set this up so that each biweekly pay period totals regular hours ending at 40 (23)and a separate cell (D24) displays OT hours.
Bookmarks