Formula for Calculating Pay

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am having trouble with an if statement that calculates pay rates. The
rules are the first 20 hours are straight time, the next 10 (Between 20 and
30 hours) are at 1.5 times the hourly rate, then anything over 30 hours is 2
times the hourly rate. I am obvoiusly multiplying all of my hours here by
it's hourly rate times 2 - I just can't seem to fit it all in without adding
additional coulmns.

Start time Stop time Hrly rate Hours worked Gross pay Correct Answer
7:00 22:57 10.75 39:57 $859.14 $590.39


Any Suggestions?

Thank you,

Denise
 
One way:

=MIN(20,Hours)*Rate+MIN(MAX(Hours-20,0),10)*Rate*1.5+MAX(Hours-30,0)*Rate*2

--
Jim
| Hello,
|
| I am having trouble with an if statement that calculates pay rates. The
| rules are the first 20 hours are straight time, the next 10 (Between 20
and
| 30 hours) are at 1.5 times the hourly rate, then anything over 30 hours is
2
| times the hourly rate. I am obvoiusly multiplying all of my hours here by
| it's hourly rate times 2 - I just can't seem to fit it all in without
adding
| additional coulmns.
|
| Start time Stop time Hrly rate Hours worked Gross pay Correct Answer
| 7:00 22:57 10.75 39:57 $859.14 $590.39
|
|
| Any Suggestions?
|
| Thank you,
|
| Denise
 
Back
Top