Can I filter a table on a time criteria?

[Tammie Carino]

I have a very large table of data in 10 minute intervals ie, 1:10:00,
1:20:00, etc. I would like to sort it to only the values (rows) for the top
of the hour, ie. 1:00:00, 2:00:00. I tried an advanced filter listing out
the 24 hour criteria. However it returned everything.

Another possibility is if I sort the data by time the data that I want is in
every 7th row. Is there a way to sort by row? or create a formula that I
could drag down to give me every 7th row? Something like =(A2). Then
=row(A8) If I highlight these two cells and drag them down the results are
A3 and A9 when I need A14 and A20 ...

Any ideas?

 

[Bill Martin]

I have a very large table of data in 10 minute intervals ie, 1:10:00,
1:20:00, etc. I would like to sort it to only the values (rows) for the top
of the hour, ie. 1:00:00, 2:00:00. I tried an advanced filter listing out
the 24 hour criteria. However it returned everything.

Another possibility is if I sort the data by time the data that I want is in
every 7th row. Is there a way to sort by row? or create a formula that I
could drag down to give me every 7th row? Something like =(A2). Then
=row(A8) If I highlight these two cells and drag them down the results are
A3 and A9 when I need A14 and A20 ...

Any ideas?

--------------------------------

If your time stamps start at A1, then the following formula copied down another
column gives you every 7th row.

=INDIRECT("A"&(ROW())*7-6)

Bill