0 Replies Latest reply on Dec 6, 2018 1:59 AM by Nathalie Demortain

    How to determine min and max of calculated lapse time

    Nathalie Demortain

      Hi!

       

      I am performing an analysis of timestamps.

      1. I have created a calculated field called "msTimeDiff" that gives me the time between 2 events within the timestamp.

      2. I need to identify the Min and Max for this "msTimeDiff" where the remark field is "repeat",

      and he Min and Max for this "msTimeDiff" where the remark field is "success".

       

      The objective is to see if the "repeat" criteria is only due to the "msTimeDiff" being very small or not.

       

      I cannot seem to find the right formula to do this as my timelapse in millisecond will update if any timestamp is moved around..

      I have used a sample of the data and attached the workbook.

       

      Thanks in advance for any help or suggestion!

      Nathalie