AnsweredAssumed Answered

Time Cards with automatic overtime

Question asked by PhantomDatabase on Dec 10, 2012
Latest reply on May 5, 2013 by O.Bass

Title

Time Cards with automatic overtime

Post

     Hey all,

     I have a database for time cards and I need to add in overtime. I would like to have the database automaically calculate these but it seems like a multi level calculation and I haven't had luck in figuring it out.

     It's a 2 parter:

     I need to calculate anything over 8 hours in a day as time and a half and 12 hours as double time

     AND

     anything over 40 hours in a week is time and a half.

      

     I can easily get it to do 1 or the other but not both.

      

     So for example:

     Monday: 8 hours

     Tuesday: 8 hours 2 OT

     Wednesday: 8 hours 4 OT 1 DOT

     Thursday: 8 hours

     Friday: 8 hours 2 OT

     (we have now hit 40 hours of regular time so automaically any hours worked are OT and over 8 is DOT)

     Saturday: 8 OT 1 DOT

     Sunday: Day off

      

     Can anyone help me with this logic? Thanks

Outcomes