Results 1 to 4 of 4

Thread: Extraction of data on interval - Excel

  1. #1
    Join Date
    Feb 2009

    Extraction of data on interval - Excel

    Here is my problem: from a given base of a data list is a time-stamped to excel 4.0 format that looks like this:

    01/01/09 23:30:53 7.45
    01/01/09 23:35:53 6.48
    01/01/09 23:35:57 5.67
    01/01/09 23:37:55 3.64

    etc, etc ...
    as you can see the time intervals are random, this is the time interval between the records when I do any changes or create any new records.

    I wish I could extract any data from this random time-stamp long after 2000 to 3000 data values according to a defined interval and that is after every hour, 5 minutes and so on...

    Either by formula or VBA

    Please Help if you have any suggestions on it!

  2. #2
    Join Date
    Dec 2008

    Re: Extraction of data on interval - Excel


    I think that the filters developed can solve your problem. you can adapt this function to your problem and can get the data or records that you want to look for, developing the filter requires the definition of a base, an area of criteria and a results area.

    Good luck,Hope this helps

  3. #3
    Join Date
    Feb 2009

    Re: Extraction of data on interval - Excel

    Thank you for the reply, but it is not exactly what I found:
    namely, in column A the date format 01/01/09 23 : 59 : 59 in column B values
    I would like to extract the following value every hour and thus have a new suite of values but spaced 1 hour.

    I may have been more clear

  4. #4
    Join Date
    Apr 2008

    Re: Extraction of data on interval - Excel


    You want to extract a single value every hour. What value do you want to extract? The last hours of the chosen?
    If you want to extract all the values between two hours, the filter designed to operate. The area criterion can be for example

     Date_hrs Date_hrs 
       > 01 / 01 / 2009 23: 00: 00 <02 / 01 / 09 00: 00: 00
    If you want to do this on every hour, multiply the area of criteria and tables of results, so I do not think this is the best solution. Perhaps a PivotTable be more appropriate but I do not handle too much.

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 10:47 AM
  2. Replies: 2
    Last Post: 09-02-2012, 06:41 PM
  3. Replies: 2
    Last Post: 22-01-2012, 11:59 AM
  4. Replies: 6
    Last Post: 17-05-2011, 11:00 PM
  5. Batch extraction in 1 Excel file
    By Pikachoo in forum Software Development
    Replies: 5
    Last Post: 27-02-2009, 02:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts