How to sort time data?

[btek]

I have hours worth of second by second data and need to sort it, but I only
need to see every 10 seconds. Is there an easier way than just either
deleting hundreds of rows or selecting them (copy and paste)? I am sure you
could also write a macro, but I am too familiar with those either.
Thank you,

[wennerberg]

I don't fully understand what you mean about "every 10 seconds", but here is the general truth about times:
Times are numbers. If you can do something with a number, you can do it with time, even if it doesn't make sense: AVERAGE, STANDARD DEVIATION, MIN, MAX, ROUND, DIVIDE, etc.
...Except that time values cannot be negative numbers. If you do something with time that results in negative, you get cell full of #######.

[David McRitchie]

If you have a header such as 'Time in cell B1 and the
times in the rest of column B you could use the following formula
in a helper column to find cells with seconds divisible by 10..
E2: =NOT(MOD(SECOND(B1),10))

then use Filter, Auto Filter on the helper column. for True
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"btek" <[email protected]> wrote in message news:[email protected]...
> I have hours worth of second by second data and need to sort it, but I only
> need to see every 10 seconds. Is there an easier way than just either
> deleting hundreds of rows or selecting them (copy and paste)? I am sure you
> could also write a macro, but I am too familiar with those either.
> Thank you,