AnsweredAssumed Answered

Tracking ahead and behind times in the timeclock

Question asked by 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.