Hello. I will try to be specific. At work I download some info and create graphics by hand but giving my programming experience I'm trying to create a Macro to do so. In the information that I download I can see how many pictures were uploaded to a system in a range of 7 days. The information give me the date an the time that the pictures were uploaded. Here's a picture example:

269617.png

STARTED AND FINISHED TIME JUST MEANS HOW MANY TIME THE PICTURES TOOK TO REACH THE SERVER. Now, I'm supposed to create a second graph with that information where a put THE NUMBER OF PICTURES UPLOADED TO THE SYSTEM WITH THE RANGE OF HOURS FOLLOWING THE DATE. For example, following that example, I can say that 2 pictures were uploaded from 2:00pm - 3:00pm but 4 pictures were uploaded from 7:00pm - 8:00pm. I was used to count it by hand and create a second graph but I'm sure that VBA is powerful enough to do the work. NOTE: when I download the info it doesn't come that pretty. It is not in order and it only shows me the date. For me to put it in order and show me both, time and date, I created this VBA code:

Please Login or Register  to view this content.
It works fine. This is an example of how my second excel sheet looks when I creates it by hand with the information from the first image that I gave as an example:

269612.png

So as you can see there. I need to create code some way in order for me to save in a variable or an array the number of pictures that were uploaded giving a time range. How many from 9:00am to 10:00am but also how many fromj 12:00pm - 1:00pm etc. If there's any way that you guys can help me to save that information, I could even create that second excel sheet with that colors and headers based on how many days I have. The date is taken in consideration only to know how many rows I will have in my second sheet. The information is sometimes downloaded from 5 days or 7 days. I hope that I dind't confuse you guys that much. I just want to know HOW in VBA I can save SOMEWHERE, how many pictures were uploaded within a time range. If you look at the first image that I gave as an example, you would see something like 3 or 4 rows says a time like: 10:00am, 10:25am, 10:35am and 10:45am. That would mean that 4 pictures were uploaded (that's the meaning of that data in my work) Can you help me? I have my knowledge too. Let's code a little bit!!!

Thank you advance!!!!!