I have a csv file of dtata that I can open in Excell.
The data is timestamped in coloumn D and is taken every two minutes.
I.e. the format shown in "D" is 01/01/2008 06:00:00
I need to strip out all the data apart from the ones on the hour.
One months data is 22141 rows so would take ages manually.
I tried to use the filter and put ends in 00:00 but everything dissapears.
Any help appreciated
Bookmarks