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 figure out a formula to automatically work out my pay. So say for example on a certain Saturday I worked 10 hours, in Cell A1 I would have the hours worked (10) and in cell B1 id like it to automatically work out how much I got paid. So say for example I got paid $15 an hour for the first 2 hours and then $20 an hour for the rest of the time in Cell B1 the total would say $190 (2hrs x $15 + 8hrs x $20)
Would anyone have any thoughts on how to do this?
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 figure out a formula to automatically work out my pay. So say for example on a certain Saturday I worked 10 hours, in Cell A1 I would have the hours worked (10) and in cell B1 id like it to automatically work out how much I got paid. So say for example I got paid $15 an hour for the first 2 hours and then $20 an hour for the rest of the time in Cell B1 the total would say $190 (2hrs x $15 + 8hrs x $20)
Would anyone have any thoughts on how to do this?