AnsweredAssumed Answered

Calculating Overtime

Question asked by jwaldridge on Nov 17, 2015

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?

Outcomes