Distance between timestamps in same column but different ID

Hi all,

I am facing a challenge currently. I tried the forum below but I need to make one extra advanced step.

Scandata has:

1. one column with date&time with minutes and seconds

2. each row identifies as a scan of an object.

3. the object therefore is maybe >100+ scanned per day/week/etc.

4. actual data set is 1.000.000 rows of scans (is group loop than an option?)

5. If no new timestamp for object ID then current date&time (duration difference)

Example data:

Time distance same column different ID.knwf

→ My goal is to identify the time difference from the same object No. which need to be added as a seperate column and connected with the rest of the columns.

Use the Group By node, group by customer ID (or whatever), and use min and max aggregation. Then calculate the difference between min and max column.

(Not possible when I have more timestamps in between)

Thank you!!