Forum Discussion
DarStro4
Aug 26, 2020Copper Contributor
Overtime pay calculation
Hello, I need help with a custom excel spreadsheet for timesheets. There spreadsheet need to calculate in a way 4 -5 different pays. What it needs to calculate is when a person works over 9 hours...
Riny_van_Eekelen
Aug 26, 2020Platinum Contributor
DarStro4 Perhaps the attached workbook can guide you to a solution for your own time sheet. I tested all sorts of hours and it seems to work as you described it. It even works if an employee works less than the regular 9 hours per day.