time calculations

[Guest]

I need to calulate time of employees worked for the passed seven days, (to
ensure they are not working over 64 hrs in one week). Their assigned work
has set shift and we need to calculate the overtime. I have defaulted the
fields to each employees regularly scheduled work hours. Now I need to add
or subtract any additional work or work not completed. I also need a running
7 day total of all hours worked. Any help with this would be aprreciated

 

[[MVP] S.Clark]

The basic function to determine a difference in time(or dates) is DateDiff()

Datediff("n", #12/5/2005 5:00 PM#, #12/5/2005 5:45 PM#) = 45

See the Help file for more info on this function.