increment different minute in random range for each ID vba

Hi I'm trying to increment the time in range size at least ( 2 min to 10 minute ) for each same ID in vba code example table:
ID time
1 5:5
1 5:7
1 5:9
2 10:10
2 10:15
2 10:20

Please Login or Register  to view this content.

the attachment first sheet is my data the result I except is in second sheet , in sheet2 I add for the ID=1 Time+2 min and ID=2 Time+4
I didn't know how to it any idea for that?

Try like this?

Please Login or Register  to view this content.

WBD

Originally Posted by WideBoyDixon

Try like this?

Please Login or Register  to view this content.

WBD

thanks alot
I tried this code but it increment the whole column 0:04 minute (I want to make the increment random range from 2 minute to 10 minute) I mean for the first ID number increment the time 2 minute for the second ID number increment 5 minute and so on..how can I do that?