3 Replies Latest reply: Mar 5, 2017 4:17 PM by Marco Wedel RSS

    Find number of minutes used in an hour

    Andrew Moberg

      I need to evaluate the total number of room minutes used for each hour in a day.

      For example between 0:00 AM and 1:00 AM there were 3 cases.

      Case 1 enters at 0:20 and leaves at 3:20

      Case 2 enters at 0:55 and leaves at 2:15

      Case 3 enters at 0:35 and leaves at 1:30

       

      Room minutes for 0:00-1:00 would be 70 minutes (1:00 - 0:20 = 40 MINS, 1:00 - 0:55 = 5 MINS, 1:00 - 0:35 = 25 MINS)

      I would then need to iterate through each hour of the day.

       

      I tried interval match which was able to get me the count of cases for each hour, but I could not figure out how to calculate the sum of minutes used in said hour.

       

      Thank you