Get Time Difference between Row 2 and Row 1, with respect to Dimensions

[caltang]

The data frame looks like this:

ID	Date	Device ID	Seller ID	Initial Time
1001	10th Oct 2022	1001-1	8000	10:26:33
1001	10th Oct 2022	1001-1	8000	10:34:33
1002	10th Oct 2022	1002-1	9000	15:04:12

Basically, I want the difference between rows. For example, for ID 1001 - The time difference is 8 minutes. 

I want to do it on Alteryx for 600k rows - all with respect to the ID and Seller ID.

How can I do this?

[grazitti_sapna · Accepted solution]

Hi @caltang , you can use multi-row formula tool to get your result. Please find the solution and screenshot. And do accept my solution if it was helpful.

[Qiu]

@caltang 
I made some improvement to the solution above to consider the date difference just in case.

[binuacs]

@caltang Similar to @Qiu and @grazitti_sapna solution

[Emmanuel_G]

@caltang 

Find in attachement the easiest way to do that I think.

Let me know if the solution works on your side.

[caltang]

Dear @grazitti_sapna @Qiu @binuacs @Emmanuel_G 

All your solutions work perfectly! I've actually did it myself and forgot to update the thread. But my solution is similar to what you all wrote.

Thank you!