Vba macro code for grouping the data based on 2 hours time

[dharani suresh]

VBA MACRO CODE FOR GROUPING THE DATA BASED ON 2 HOURS TIME...
Hello Experts,

I need a VBA macro code to get the output like in the excel file which I have attached with this thread. Which means, I need to group the data for every two hours. in the output I need all 4 cols namely A, B, C, D along with extra col namely, interval based on which I need these groupings to be done..

I did manually for your kind reference and easy understanding... please find the attachment.... in the excel sheet I have explained still more clearly, please refer that...

A kind request, the code has to be really flexible so that it works for all dates and times in the files. because like this I have to do for 2000 files.....
I hope I am clear and I am not confusing you experts and also I hope for experts like you this code will be easier to write...
for further clarification, I am very much ready to answer you...

Looking forward for the positive reply..... please do the needful...
Thank you,

With kind regards,


Dharani.