6 Replies Latest reply on Mar 10, 2020 5:59 AM by Gopal Desai

    Datediff by subtracting 2 Rows

    Gopal Desai

      Hello everyone,

       

      I would like calculate Date & time difference from 2 different Rows. I have 6 Stations(Column1). I would like calculate datetime difference between 1st station and last station. For Example value 4B6B831A, It should show me time difference between Arbeitsplatz1(1st Station) and Arbeitsplatz19(last Station). Here it should be 04.03.2020 13:54:38 - 04.03.2020 13:49:29 = 00:04:51. This time difference should show in 4th column in row

      Station                Timestamp                   wERT-1          Durchlaufzeit

      Arbeitsplatz19    04.03.2020 13.54:38    4B6B831A      00:04:51.

      I am trying to solve this thing with lookup and Table Calculation. But it's not Happening. If anyone could you please help me out. I am attaching my workbook.

      Thank you.

      table.pngtable1.png