0 Replies Latest reply on Dec 6, 2014 11:48 AM by ericjlindholm

    Amount of time summery help

    ericjlindholm

      Title

      Amount of time summery help

      Post

       

      I have a table of schedule times.  each time has a check box that displays users from the available labor pool for that event.  I would like to calculate the amount of time a user is schedule to be on site.  

       

       
      The most complicated part is that a user might be on site for a period of time and then off site and then return.  
       
      I would need to sum the total amount of time between 2 the first and last time a user is associated with.  For example:
       
      7:00 am - Pick up truck at warehouse - user 1
      8:00 am - Call time on site - user 1, 2, 3
      10:00 am - User 1 leave for next delivery- User 1
      12:00 pm -Event Start - User 2,3
      5:00 PM - Event end, Strike and truck back on site - User 1,2,3
      8:00 pm- Strike end - User 1,2,3
      9:00 pm - return truck to warehouse - User 1
       
      Time on site Summary needed  from related user record
       
      User 1 - 7 Hours
      User 2 - 12 hours
      User 3 - 12 hours
       
       
      I fear I will need more input in the scheduling table to make this work if it is even possible
       
       
       
      I have 2 tables related to each user from the labor pool.  one contains related times in ascending order and the other contains related times in descending order.  From the labor pool record, i have a calc that gets me the amount of time on site.  it works perfectly but it does not take into account the scenario were a user is schedule to go off site and return