|
|
#1
04-27-2014, 10:21 PM
|
|||
|
|||
Vba macro code for grouping the data based on 2 hours time
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Pivot table grouping problem 2 tables need different grouping
|
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
| Calculations based off of unsorted data | custermd | Excel | 1 | 05-04-2012 08:12 AM |
| Modify vba code to print based on name in the InputBox | OTPM | Project | 0 | 05-25-2011 02:03 AM |
|
field value based on time of day
|
akraw | Word | 3 | 03-26-2011 08:29 PM |
|
Date and time calcs excluding non-working hours
|
mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
Windows 7 32bit 
Office 2007
Threaded Mode