6 Replies Latest reply on Sep 18, 2017 9:12 AM by Motorola Licenses

    Calculation query - Dynamic values

    Motorola Licenses

      Hello,

       

      I need help to calculate downtime with the below criteria  for the attached workbook:

       

      Timestamp - mm/dd/yyyy hh:mm:ss

      Severity - Critical and Clear

      Downtime to be calculated

       

      If 'hh' value for critical and clear match, then downtime = timestamp(Clear) minus timestamp(Critical)

       

      If 'hh' dont match, then

      Downtime for Critical record = (hh+1 from critical timestamp) - (Critical timestamp)

      and

      Downtime for Clear record = (Clear Timestamp) - (hh value from clear timestamp)