Somewhat complicated...at least for me. Our company does not pay overtime (don't ask....it's a trucking company and falls under Intrastate exemption).



I'm trying to back into the ACTUAL earned hourly rate if an employee WAS paid overtime.

For instance;
Employee "A" earned $1,000 for the week, but worked 50-hours. His current Earned Hourly rate is $20 for ALL hours worked.

If we were to pay O.T at 1.5X, what would his "straight" time be for the first 40-hours?
I.E., Straight time rate = $XX (X) 40-hours
Overtime rate = $XX (X) 10-hours.

Is there a formula that can be built to reflect such?

Hi
of course.
Suppose total hours is in A1
=MIN(A1,40)*normal_rate+MAX(A1-40,0)*normal_rate*1.5

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I'll give it a try. Thanks so much for the help.