0

Dear friends,

I have a set of files created at certaing time. I would like to group the result where consecutive time difference is more than 1 minute.

For example

A 10:01:25

B 10:01:29

C 10:01:52

D 10:01:58

E 10:02:12

F 10:02:22

G 10:11:01

H 10:11:18

I 10:30:00

The above should result in

Group1

A 10:01:25

B 10:01:29

C 10:01:52

D 10:01:58

E 10:02:12

F 10:02:22

Group2

G 10:11:01

H 10:11:18

Group3

I 10:30:00

This is because the difference between a and b, b and c,...e and f is lower than 1 minute. F and G are about 9 minutes apart, so I need another group here.

I mean, the difference should be done each with the next in alphabetic order (and values are already provided in alphabetic order).

What would be the best approach?

Thanks