My brother in law has a timesheet issue that I am hoping to help him with using msAccess. I am having trouble thinking through the structure so I thought maybe I could type it out here and see if anyone has any ideas.
Each employee works three 12 hour days the first week and one 8 hour day. The way the overtime laws work the employee will split the last day of the first week into 2 parts of 4 hrs each. The second week they work three 12 hour days (plus the 4 hours from the previous works gets added to week 2)
Hope that makes since, i'll try to show example below:
Week 1
Mon Tue Wed Thur
12 12 12 8
Week 2
Mon Tue Wed
12 12 12
4 of the hours on the Thursday will go into Week 2s payroll so neither week is over 40 hours and they won't have to pay overtime.
In case you want to help with issue 2, if there is overtime on the split day (Thursday above), then it depends on the employees start time whether it goes on week 1 or week 2. Each employee group could start at 8am, 12am, 4pm or 8pm. If the employee starts in the 8pm slot his overtime would go to the next week.
Does this make since?
I'm really struggling to figure out how to share a day of data into two different weeks.
Each employee works three 12 hour days the first week and one 8 hour day. The way the overtime laws work the employee will split the last day of the first week into 2 parts of 4 hrs each. The second week they work three 12 hour days (plus the 4 hours from the previous works gets added to week 2)
Hope that makes since, i'll try to show example below:
Week 1
Mon Tue Wed Thur
12 12 12 8
Week 2
Mon Tue Wed
12 12 12
4 of the hours on the Thursday will go into Week 2s payroll so neither week is over 40 hours and they won't have to pay overtime.
In case you want to help with issue 2, if there is overtime on the split day (Thursday above), then it depends on the employees start time whether it goes on week 1 or week 2. Each employee group could start at 8am, 12am, 4pm or 8pm. If the employee starts in the 8pm slot his overtime would go to the next week.
Does this make since?
I'm really struggling to figure out how to share a day of data into two different weeks.