0 Replies Latest reply on Nov 17, 2015 6:53 PM by jwaldridge

    Calculating Overtime

    jwaldridge

      My database is set up so that i have an employee table and a time card table

       

      I currently sort  the time card table by two week intervals to produce a report of total time.  What I would like to do is add a script that will calculate the weekday totals by weeks to calculate overtime 

       

      For example...

      Assuming that Sunday is day one and we are sorting two weeks,

       

      I would like to calculate the total time for day 2-6 and put it in a global field, if that field is greater then 40 subtract the difference from Straight time and add it to over time

       

      then

       

      I would like to calculate the total time for days 9-13 put that in a global field. if that filed was greater then 40 subtract the diferacnce from straight time and add it to overtime

       

      I have a checkbox for automatically putting time in overtime for weekends and holidays. This is really meant to figure out if my total time in a single week (Monday -Friday)  exceeds 40 and then adjust for overtime

       

      Im not sure the best way to do this any ideas?