Ok, I have been searching for over a week trying to find a simple way to create this, but I am officially stumped.
Basically, I need to create a timesheet for our crew. We run on a semi-monthly payroll, periods being 1-15 & 16-31. Our crew automatically gets paid overtime for anything worked over 40 hours a week (which means I usually have to pull time from the previous pay period if the current pay period started in the middle of the week). They also automatically get paid overtime on weekends, regardless of the number of hours worked. I do not need this to calculate the actual pay, just the total number of hours for regular and overtime pay.
They are also allowed two unpaid breaks per day, so there are three log in/log out fields per day. I already have the calculations to add the time for the day together, but am stumped when it comes to calculating whether the week has reached 40 hours or to have it automatically know if the day of the week is on a weekend.
Anybody have any ideas how to accomplish this?