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

    Calculation query - Dynamic values

    Motorola Licenses



      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)


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