4 Replies Latest reply: Nov 28, 2016 12:41 PM by Stefan Wühl RSS

    Subtract next row with the current row ??

    gaurav gopale

      Hi ,

       

      in the following table  where the Status_id = 4 i have to calculate the Result Cloumn by subtracting the update_date_time

      highlighted in Orange-  update_date_time in Green in HH:MM:SS

          

      id_pkResult Column(HH:MM:SS)Status idupdate_date_time
      5632712016-07-26 11:47:36
      5632822016-07-26 11:47:59
      5633032016-07-26 11:48:30
      563312016-07-26 11:49:29 - 2016-07-26 11:48:41=00:00:4842016-07-26 11:48:41
      5633242016-07-26 11:49:29
      5633432016-07-26 11:51:20