Time Sheet Calculations

[MikeDWi]

Hi folks,
I am pretty new to using excel formulas and I have tried but I can't seem to figure this one out... I am trying to do a time sheet and on Saturdays being overtime for the first 2 hours I get paid at one rate, and after the first 2 hours I get paid another rate, I am trying to work out a formula to work it out I had come up with the below where for example 10 was the pay rate for the first 2 hours and 20 being the pay rate for anything after that (A2 being hours worked column)

=10*MIN(2,A2)+20*(A2-2)

I thought it was going to work however its not quite right.. its probably an easy fix I just can't seem to figure it out. Any help would be greatly appreciated

[Keebellah]

Hi, you will have to use a two-stage formula for the Saturday, the first part checks the rate for the max first two hours and yhen you + and another if statmenet is the total hours <= 2 the answer is 0 este it's the diffrenece of the towtal hours minus the first two.
Hope it makes sense.
I suggest you attach a sample file where it will be easier to show than explain