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

    Calculating Overtime

    m3m3m3

      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
          philmodjunk

          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