Formula for Calculating Pay

[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

 

[Jim Rech]

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