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

      Hello

       

      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