I have a time card database which is almost complete, but I don't know how to tell it to calculate overtime if someone works more than 40 hours in a week.
I have it set up so that one day is one record, and our payroll is biweekly, so two weeks makes up a pay period.
I have a payroll report that groups the records for each pay period by employee. Regular time and overtime are calculated on each record, and totals are added up with summary fields in the payroll report. All of this works as it should, but I realized that there is no way for the report to know if someone worked more than 40 regular hours in a week (which would go into overtime).
The challenge is that two weeks makes up a pay period, so I think I will need to somehow indicate when a week starts and ends. I have a table for Pay Periods, which associates dates with start/end dates for the pay period, but I'm not sure where to go from there.
Please let me know if anyone has suggestions, or if you need more information.
Thank you for any help!