Filtering Data Every 10 or 30 minutes

[jilex21]

Background:
The data collected from our proprietary software can be converted into Excel format using the file conversion utility. The data collected is for every minute. The 3-4 day run can generate 50000 rows. The first column is Date/time in the format of mm/dd/yyyy hh:mm AM/PM.

My question: How do we filter the data so that it will only show every 10 or 30 minutes, instead of every minute?

 

[Andrew Fergus]

any chance you would know how to average the data. For instance, I am logging temperature data at 1 second intervals. I am looking to take the average over the previous 60 seconds so my data is in Minutes. Any suggestions?

Welcome to MrExcel. Can you elaborate on how the data is stored and how you want it presented? For instance, do you have a row of data for each second? And I presume you want to take blocks of 60 rows at a time and present the average for each minute on a separate sheet - is that correct?