Sorting and Auto deleting long Date and Time series

Hey guys, am a Master student working on a project and I have to deal with huge amounts of data. I have this Meteorological data that takes records with a 5minuts interval every month. So basically all day every day every 5minuts there is a measurement. Now I want to automatically delete the 5 minutes intervals with the entire row of records and leave only the data collected every 10 minutes. The problem is the date and time series are not recorded as formulas so I cannot modify any kind of formula to adjust the data range. I would like to know if there are any shortcuts otherwise I will have to empty every row manually and for every month there are at least 8600 cells! 

By: Rc23

Leave a Reply

Your email address will not be published. Required fields are marked *