payroll overtime formula

[K]

trying to figure out formula for 1 1/2 x overtime between
8 & 12 hours only. (over 12 goes to 2 x but I have that in
a different cell.)
Help!?
Please help if you can.
Thank you!
k

 

[Gord Dibben]

K

Check out Chip Pearson's page on Timesheets.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben XL2002