Forum Discussion
Solved
Calculate overtime rates with different hourly rate (2am to 5am)
I need to calculate overtime with different hourly rate from 2am to 5am. I have been breaking my head on this. Can you help?
| 20% additional hourly rate for overtime hours | Upto 50 hours a week |
| 15% additional hourly rate for overtime hours | Above 50 hours a week |
| 25% additional hourly rate for overtime hours | Between 2am to 5am |
The file that you sent me looks like homework, so I will just give you the formula for the overtime hours between 2:00 AM and 5:00 AM.
You should try to calculate the totals yourself - you'll learn more that way.
I corrected some values in the file:
I entered 4:00 AM in C9, 5:00 AM in L3 and 2:00 AM in L4. The original value in each of these cells contained a date as well as a time. I also removed the date component from D9:D22.
See the attached version.
The file that you sent me looks like homework, so I will just give you the formula for the overtime hours between 2:00 AM and 5:00 AM.
You should try to calculate the totals yourself - you'll learn more that way.
I corrected some values in the file:
I entered 4:00 AM in C9, 5:00 AM in L3 and 2:00 AM in L4. The original value in each of these cells contained a date as well as a time. I also removed the date component from D9:D22.
See the attached version.
