One way:

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

--
Jim
"Denise" wrote in message
...
| 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