8 Replies Latest reply: Aug 5, 2015 2:15 AM by manoj nair RSS

    Sum of Time Intervals

    kevin tenggara

      Hi All,


      I am having trouble with summing up time intervals. My data has the start and end time for an employee and I have calculated the gap between the time using the Interval function.

       

      Furthermore, each employee is also assigned a warehouse number and I am trying to sum up the gap per warehouse number. I find that the number I get is usually double the actual number that I've manually calculated on Excel, meaning there is an obvious error.

       

      An example of the data is:

      Warehouse #Employee #Scan inScan OutGap

      1

      5611:00:0011:09:009
      15511:30:0011:46:0016
      24511:35:0011:40:005
      27511:46:0011:50:004
      38911:56:0011:57:001
      37811:58:0012:00:002

       

      Naturally, the correct data would be:

      Warehouse#          Sum of Gaps

      1                         25

      2                         9

      3                         3

       

      However I am getting exactly four times the expected values. Does anyone know why this occurs and how to fix the issue?

       

      Thanks and I appreciate any reply greatly.