Need assistance to create multiple entries from one using VBA.

Hi Everyone,

I need a slight help to create multiple entries from the original using VBA magic. In a nutshell, here's what I want to do:

Original Entry: 1111111111 512345 6/4/2013 10:49:03 AM

I need to replicate this entry by adding and deducting 5 minutes. My expected output is:

1111111111 512345 6/4/2013 10:44:03 AM
1111111111 512345 6/4/2013 10:49:03 AM
1111111111 512345 6/4/2013 10:54:03 AM

Please see attached spreadsheet for some more examples.

Thank you in advance for your help!

Regards,
ILI