

 Thread Tools  Search this Thread 
#1
 
 
Extraction of data on interval  Excel
Hello, Here is my problem: from a given base of a data list is a timestamped 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 timestamp 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
 
 
Re: Extraction of data on interval  Excel
Hello, 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
 
 
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
 
 
Re: Extraction of data on interval  Excel
Hello, 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 Code: Date_hrs Date_hrs > 01 / 01 / 2009 23: 00: 00 <02 / 01 / 09 00: 00: 00 

Tags: excel, extraction data, records, time stamp 
Thread Tools  Search this Thread 

Similar Threads for: "Extraction of data on interval  Excel"  
Thread  Thread Starter  Forum  Replies  Last Post 
How to convert monthly data into quarterly data in Microsoft Excel  Glasney  MS Office Support  4  04012014 10:47 AM 
Need help to compute a 75% chebyshev interval around the mean in Excel  Edha  MS Office Support  2  09022012 06:41 PM 
How to insert the corresponding data into multiple worksheets from a range of data in Excel  ZaidaB  Windows Software  2  22012012 11:59 AM 
How to check data validation compatibility of excel 2010 on excel 2007  Zoello  Windows Software  6  17052011 11:00 PM 
Batch extraction in 1 Excel file  Pikachoo  Software Development  5  27022009 02:00 PM 