AnsweredAssumed Answered

What is the best way to Subtract the start time from end time from two different entries with the same date.

Question asked by carrillas on Jun 8, 2018
Latest reply on Jun 8, 2018 by philmodjunk

I am working on a solution that tracks customer's attendance and use of assigned space and I am trying to figure out the best way to to this. The requirement is that each customer has to use their assigned space a minimum of 6 hours per day, 20 days per month. I have a table that has all the customer information and I am creating a separate table to tack their attendance. My staff conducts two separate attendance check one in the morning and one in the afternoon. Does anyone have a suggestion on how best to configure this task?