Struggling with creating a formula for twice monthly overtime pay
Hello! I am trying to create a spreadsheet to track my husband's hours and pay. He gets paid twice a month on set days. I have everything figured out except how to calculate the overtime pay. They get overtime for anything over 40hrs per week. The confusion comes in because their overtime is calculated from Sunday to Saturday (their work week) even if the pay period ends in the middle of this time frame. For example if his pay period is the 1st thru the 15th and the 15th happens to land on a Wednesday but he ends up with overtime that week it reflects on the next check since the end of that work week landed on the next paycheck. I am at a loss on how to create a formula to factor in this split. Thank you!
Edit: He just started so I don't really have any data but here is a screenshot of what I have set up so far. His pay periods are 1st-15th and the 16th-end of the month, his work week is Sunday to Saturday.
[link] [comments]
Want to read more?
Check out the full article on the original site