I am trying to create a spreadsheet that calculates overtime.
<tbody>
</tbody>
I was wondering if there was a formula or combination of formulas that would calculate this for me. On day 5 the employee went into overtime (over 40 hours) and should be paid 1.5 times there rate of pay. For example the employee normally makes $12 an hour. On days 1-4 they would receive $12 times their hours worked. On day 5 they go into overtime (over 40 hours) so they would get 5 hours at regular pay and 4 hours at $12 times 1.5, or an overtime rate of $18. I wanted to fill in cells with the regular hourly rate and overtime and have the spreadsheet calculate how much they would make based on the hours they worked.
Thank You!
Day1 | Day2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | |
Employee Hours | 8 | 9 | 8 | 10 | 9 | 5 | 0 |
Total Hours | 8 | 17 | 25 | 35 | 44 | 49 | 49 |
Overtime | 0 | 0 | 0 | 0 | 4 | 9 | 9 |
<tbody>
</tbody>
I was wondering if there was a formula or combination of formulas that would calculate this for me. On day 5 the employee went into overtime (over 40 hours) and should be paid 1.5 times there rate of pay. For example the employee normally makes $12 an hour. On days 1-4 they would receive $12 times their hours worked. On day 5 they go into overtime (over 40 hours) so they would get 5 hours at regular pay and 4 hours at $12 times 1.5, or an overtime rate of $18. I wanted to fill in cells with the regular hourly rate and overtime and have the spreadsheet calculate how much they would make based on the hours they worked.
Thank You!