SOLVED

Calculate overtime rates with different hourly rate (2am to 5am)

Copper Contributor

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

2 Replies
best response confirmed by sid_asks (Copper Contributor)
Solution

Re: Calculate overtime rates with different hourly rate (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.

Re: Calculate overtime rates with different hourly rate (2am to 5am)

Thank you so much. It works like a charm.

Kudos

1 best response

Accepted Solutions
best response confirmed by sid_asks (Copper Contributor)
Solution

Re: Calculate overtime rates with different hourly rate (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.