5 Replies Latest reply on Aug 20, 2018 3:56 PM by Joseph Kulasa

    Need average of time elapsed between entries

    Joseph Kulasa

      My plant currently requires a sample to be taken every two hours per machine (there are 15 machines).  My data includes a unique identifier (sample number), the machine that took the sample, and a date/time column.  I've attempted to get the time duration calculated field, which is included within the "time between entries" field.  This field was then converted to an "hh:mm:ss" format by dividing time between entries by 86400 (date time calculation).

       

      I need my data to be the average of each CPM 1 for day, so it would ideally have all CPMs with the average time between samples in a separate column.