[SOLVED] Filtering for rows within every 30 seconds interval

Filtering for rows within every 30 seconds interval

I have a large data file from a test where I send a voltage that is increment by 1mv every 30s from 0-5V) to test the accuracy of my system. The computer outputs a file that has over 70000 rows of data but all I am really concerned with is data that occurs every 30s. Is there a way to filter for only the data that aligns with the 30s interval and ideally having around 5000 rows of data?

I am stuck and I really don't want to manually sort through 70000 lines of data, any help is greatly appreciated..

Solution

So you want to filter and only see the rows that occur every 30 seconds? You can add a calculated column in Excel to extract the seconds and filter by that column:

=RIGHT(TEXT(A1, "hh:mm:ss"),2)

This will extract the seconds from a time, and then you can filter where the seconds are 30. Replace A1 with your correct column.