Calculating Overtime
Hi I'm trying to make a calculator that calculates overtime rates. The first field would be the rate for the first 10 hours (which you would type in), and then the next field would be after ten hours, then the next field would be after 12 hours. After ten hours the rate is increased to time and a half, after 12 the rate is double.
As soon as you input a number into the first field, I would like for the other fields to automatically calculate the other rates.
This is simple, but I am stumped--I know I can do this through a calculation but I think I'm missing a step somewhere.
For the after 10 I have the calculation
= (Rate / 10) * 1.5
For after 12 I have
= (Rate /12) * 2
FileMaker Pro 11 on Mac OS 10.6.4
My sympathies to the employees. Around here, law requires time and a half after 8 hours regular time...
Field1, totalhours--all the hours the employeeworked that day.
Field2, RegularTime
Min ( TotalHours ; 8 ) * rate
Field 3, TimeAndAHalf,
Case ( TotalHours > 10 ; min ( ( TotalHours - 10 ) * 1.5 ; 3 ) ; 0 ) * rate
Field 4, DoubleTime
If ( TotalHours > 12 ; (Total Hours - 12 ) * 2 ; 0 ) * Rate