Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sort time data?
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, |
#2
|
|||
|
|||
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 #######. -- wennerberg ------------------------------------------------------------------------ wennerberg's Profile: http://www.excelforum.com/member.php...fo&userid=7321 View this thread: http://www.excelforum.com/showthread...hreadid=471219 |
#3
|
|||
|
|||
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" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Summing Time Data | Excel Discussion (Misc queries) | |||
Time "and" Date for data points | Charts and Charting in Excel | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions |