16 Replies Latest reply: Jul 29, 2016 4:58 PM by Vineeth Pujari RSS

    How to calculate elapse time between two dates in the same field

    Branislav Bujnak

      Dear Community:

       

      I have a challenge to calculate elapse time between different time stamps of steps in activity.

       

       

      ID, Activity ID, Step ID, CreateDate,

      1, 1, 1-1, 1/1/16 05:00:10,

      2, 1, 1-3, 1/1/2016 05:05:00,

      3, 1, 1-5, 1/1/2016 06:10:00

       

       

      I am trying to create ElapseTime Fields that will calculate the time difference between the timestamps in the same activity

       

       

      My result field should look like the following

       

      ID, ID, Activity ID, Step ID, CreateDate, ElapseTime

       

      1, 1, 1-1, 1/1/16 05:00:10, 0

      2, 1, 1-3, 1/1/2016 05:05:00, 00:04:50

      3, 1, 1-5, 1/1/2016 06:10:00, 01:05:00

       

      Thanks for your help once again.