1 Reply Latest reply on Aug 4, 2010 11:24 AM by philmodjunk

# Calculating Overtime

### Title

Calculating Overtime

### Post

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

• ###### 1. Re: Calculating Overtime

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