Finding difference in hours for DateTime in adjacent rows

[karthik2020]

Hi,

I am trying to find the difference in hours between DateTime in adjacent rows( N -  (N-1) row)

Can you let me know if this is feasible? I tried using existing samples online but facing errors. Thank you.

[StephaneP]

Hello @karthik2020 ,

If I have well understood here is a way of doing it

You 1st need to convert your test as a date

+ using the formula DateTime Diff calculate the difference between 2 value

I have used the multirow tool as my data are on different rows. But if they are in different column you can use only the formula tool.

Hope it helps