Excel Records Comparision based on Time (Help with VBA Logic)

Dear Gurus,

I have a complex issue to be solved (complex enough for me at this moment). Please help me achieve this VBA code.

I have a list of records with Date and Time, from this we need to scan through the time and pick those samples at designated timings. E.g: There are 50 samples with date and time as below:

Compulsory Record Time SelectionsMade
0 26/06/201200:04
0 26/06/2012 00:16
0 26/06/2012 00:25 YES
0 26/06/2012 00:36
0 26/06/2012 00:46
1 26/06/2012 00:57 YES
0 26/06/2012 01:07
0 26/06/2012 01:17 YES
0 26/06/2012 01:39
0 26/06/2012 01:49
1 26/06/2012 02:07 YES
0 26/06/2012 02:11
0 26/06/2012 02:23 YES
0 26/06/2012 02:34
0 26/06/2012 02:44
0 26/06/2012 02:54
0 26/06/2012 03:05
0 26/06/2012 03:15
0 26/06/2012 03:26 YES
0 26/06/2012 03:37

I have to pick the samples at 00:30, 1:30, 2:30 and 3:30. So in case of the last two records at "3:26 & 3:37", I'll pick the "3:26" sample and mark it with a "1" in the cell adjacent to it. Similarly between records with "2:23 & 2:34", I'll pick "2:23" (Ofcourse I got the data sorted in ascending order of time).

One more small additional requirement is certain records are marked as 1 in the adjacent column, which got to be SELECTED, whether they fall in the time frame or not in addition to the other samples.

I am unable to achieve this logic. Your help will be greatly appreciated.

Thanks in advance.

Regards,
RK.

Bump!

Can anyone please help with this code?

Bump!

Guys, can any one help me with the VBA code for this? Your help will be appreciated a lot.

Thanks,

Regards,
RK.