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.

Attached Files

plant area.xlsx (40.0 KB, 11 views)

Cross-posted at: http://windowssecrets.com/forums/sho...hlight=Dharani
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Also, when posting Excel topics, please use the appropriate Excel forum, not one of the Word forums.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

How to remove this post?

I have already moved it to the correct forum, so there is no need to delete.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

so nice of you admin... thank you... now i got answer for this thread.. how i will mark this thread as a solved one... and can you please tell me, to which forum you moved this thread??? so that i will close this thread... i should not waste others time thats y...

Thank you...
Dharani...

There is a option for marking threads as solved on the 'Thread Tools' dropdown at the top of the thread. I've done that for you.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]