AnsweredAssumed Answered

Tracking ahead and behind times in the timeclock

Question asked by sfishman@ou.edu on Nov 7, 2016
Latest reply on Nov 7, 2016 by Johan Hedman

Our students are required to work a set number of hours a week, which is accumulative over time each week. For example, if someone works 25 hours and is supposed to work 20, then they accumulate 5 hours flex time.  And, if that same person works 22 hours the second week, they now have 7 hours flex time towards vacation.

 

I was able to do this in the Microsoft access database: =Sum([Subtotal])-[GlobalTimeWorked] and sorted the report by start time and placed this field in that section.  However, I don't know how to replicate it in FileMaker (version 12).

 

I have the report sorted correctly so it parses out each week.  I have the calculation to total the amount of time worked that week.  But, I can't get it to calculate accumulate time worked over multiple weeks.

Outcomes