12 Replies Latest reply: May 16, 2017 10:54 AM by Andrew Moberg RSS

    Find time difference in minutes between end time and begin time of consecutive IDs

    Andrew Moberg



      Can anyone recommend a way to calculate the time difference between the end time of one event and the beginning time of the next event?

      For example

      LOG 1234

      Start 7:20

      End 7:40


      LOG 5678

      Start 7:45

      End 8:00


      The gap between LOG 1234 end and LOG 5678 start is 5 minutes.


      Thanks in advance