Payroll calculation

[Baylah]

this has probably been asked in the past but I have not been aboe to find the answer in Archives.

How can I write a calculation that will automatically factor for overtime pay without having to have a second field for hours over 40?

In other words if Pay_Hours > 40, 40hrs at "X" rate, remaining hours, "X" rate X 1.50.

Thanks for any help you all can give.

Steve

[LaRetta]

Hi Steve,

Of course it isn't as simple as this. This doesn't account for weekends or holiday pay (double-time etc). It really is better to use another table because it adds to your flexibility. But, assuming you have an Hours field and a Rate field, here is one way:

Let ( [

base = 40 ;

OT = Hours - base ] ;

If ( Hours > base ; base * Rate + OT * ( Rate + Rate / 2 ) ; Hours * Rate )

)

LaRetta

[comment]

How about:

hours * rate + Case ( hours > 40 ; ( hours - 40 ) * rate * 0.5 )