2 Replies Latest reply on Nov 7, 2016 8:22 AM by Johan Hedman

    Tracking ahead and behind times in the timeclock


      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.