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