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
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
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?