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 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?

 

[etaf]

A1 = 10
B1 = If ( A1 >=2 , ((A1-2)*20) + 30 ) , IF( A1 >0 , A1*15 , 0 ))
you can have the 20 & 15 rates in different cells as use those , so if the rate changes all you need to do is update the rate and not all the formulas

If you post your spreadsheet here using XL2BB , then we can add to the spreadsheet

Assume normal rate is in C1 & OT in D1
B1 = If ( A1 >=2 , ((A1-2)*D1) + (C1*2) ) , IF( A1 >0 , A1*C1 , 0 ))

 

[ExceLoki]

here's one way
------------

Book1
	A	B
1	hours	pay
2	10	190
3	12	230
4	14	270
5	8	150
6	6	110
7	11	210
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=IF(A2="","",((2*15)+(A2-2)*20))

 

[Mikedwi]

Awesome!! Cheers folks thank you so much!!

 

[etaf]

You are Welcome