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