Overtime Calulator

[pmw19800]

Hello

i need a calculator to track what people get paid in terms of over time,

If someone works 6 hours: 4 hours is paid @ 1.33 anything after 4 hours is paid @ 1.5

So I want to enter 6 In A1 and C1 to return total money to pay, ideally i need this in 1 formula

any help would be great

Paul

[JohnTopley]

Try

(MIN(4,A2)*1.33+MAX(0,A2-4)*1.5)*B2


=(MIN(4,$A$2)*$A$4+MAX(0,$A$2-4)*$B$4)*$B$2