Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Extraction of data on interval - Excel

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-02-2009
Member
 
Join Date: Feb 2009
Posts: 117
Extraction of data on interval - Excel
  

Hello,
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!

Reply With Quote
  #2  
Old 16-02-2009
Member
 
Join Date: Dec 2008
Posts: 183
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
Reply With Quote
  #3  
Old 16-02-2009
Member
 
Join Date: Feb 2009
Posts: 117
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
Reply With Quote
  #4  
Old 16-02-2009
Member
 
Join Date: Apr 2008
Posts: 193
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
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 04-01-2014 09:47 AM
Need help to compute a 75% chebyshev interval around the mean in Excel Edha MS Office Support 2 09-02-2012 05:41 PM
How to insert the corresponding data into multiple worksheets from a range of data in Excel ZaidaB Windows Software 2 22-01-2012 10:59 AM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM
Batch extraction in 1 Excel file Pikachoo Software Development 5 27-02-2009 01:00 PM


All times are GMT +5.5. The time now is 01:23 PM.