Safety_3rd
New Member
- Joined
- Sep 17, 2014
- Messages
- 6
I have a list days and clock in and out times. I would like to calculate the total number of hours worked in a work week. The work week begins midnight Sunday and ends at 11:59:59 Saturday. The punch in and out times are in military format. Employees don't work every day of the week. My problems are that if an employee clocks in Saturday at 22:00 and out at 04:15 on Sunday morning 2 hours will go on the previous week and 4:15 hours in the start of the next week. The total hours need to be in decimal form not hh:mm:ss, and I cant just auto sum every 7 lines because an employee might only work 4 days in one week but all 7 in the next week. Any help would be great! Thank you.
<tbody>
</tbody>
Day of week | Punch in | Punch out | Hours |
Saturday | 22:00 | 4:15 | 6:15 |
Sunday | 04:15 | 05:30 | 1:15 |
Monday | 21:00 | 05:30 | 8:30 |
Tuesday | etc... | etc... | etc... |
Wednesday | |||
Thursday | |||
Friday | |||
Saturday | |||
Monday | |||
Tuesday | |||
Wed | |||
Thur | |||
Fir | |||
Mon | |||
Tue | |||
Wed | |||
Thur | |||
Fri | |||
Sat |
<tbody>
</tbody>