Hi there,
I am new to this forum. I am looking for a spreadsheet to calculate overtime for our employees. I don't want to reinvent the wheel if I don't have to.
I'm looking to create something that has the following criteria:
Work week is Sunday to Saturday.*
Pay periods run from 1st-15, and 15-end of the month.
Overtime is based on more that 40 hours per week (Sunday to Saturday)
Overtime is spread between paychecks based on how the pay period falls
No need to enter in time, just total hours for the day
PTO, Holiday, Sick time do not count towards overtime hours of 40+ per week.
Thank you in advance for any help you can provide!
Bookmarks