Forum Discussion
Overtime Calculation with Multiple Work Rates
This is a sample of how the sheet is set up. Ideally it would work so that Work (W) and Drive (D) hours columns are added to their respective columns on the right, until W+D combine for 40 hours, and then each hour after that would go into W/OT if W hours and D/OT if D hours. I can provide cell numbers if needed.
I think i've done it.
I'm attaching a workbook that follows the screenshot, so i'm hoping you can copy/paste your data and it will just work for you.
To explain though. It has 3 worksheets. The first (Example) is basically the sheet I used to try and work it out. I think it might be easier to understand what is happening on that sheet, but it's not usable.
The one called Data, is where you should update your records, and the last one (helpers) is where the calculations are happening. You need to make sure that there is a row of 'helpers' for every row in data.
Do test it, I've been looking at it long enough that i'm not 100% i can see it properly now :D