5 Replies Latest reply: Nov 15, 2016 8:03 AM by Sunny Talwar RSS

    How to Subtract Date from the previous row????

    gaurav gopale

      Hi

      I have the following table

       

      I have to create a New Column

       

      I have to subtract RowNo 2 from RowNo 1 for which the result should come in new column in format (HH:MM:SS)

      This should be applied for all the rows.

       

       

       

                                    TimestampNew Column(HH:MM:SS)RowNo
      08-01-2016 03:001
      08-01-2016 03:01(08-01-2016 03:01)-(08-01-2016 03:00)2
      08-01-2016 03:063
      08-01-2016 03:064
      08-01-2016 03:075
      08-01-2016 03:076
      08-01-2016 03:107
      08-01-2016 03:118
      08-01-2016 03:179
      08-01-2016 03:1910
      08-01-2016 03:2311
      08-01-2016 03:2312
      08-01-2016 03:3113
      08-01-2016 03:3414
      08-01-2016 03:4915
      08-01-2016 03:5116
      08-01-2016 03:5417