So you log your hours each day. i.e. 8,8,8,8,8 = 40 hours. but if you did 8,8,8,10,8 then on our spreadsheet you would need to log it as 8,8,8,10,6 and then 2 on the next row down.
Basically, you continue to put in your accumulated hours until you hit 40, then everything over 40 goes into the next row for OT. I've attached a sample workbook to try and make sense. inside the black box is what I am looking at. The top example is what the employees see and would enter. The orange box is how it should work. I would like to allow the employees to enter their info into the top example and the bottom would then instruct them what their timesheet should look like if filled out correctly. Hope that makes some sense!
Bookmarks