| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter By Time
I have a long list of data recorded at about 20 second intervals (sometimes
more, sometimes less). I want to filter the data so that I only retain data every 3-5 minutes. If the data were recorded exactly on the even minutes, I could just divide by 180 or 300, but it sometimes drifts off with no set pattern. Please explain how I can filter this data to sample only every 3-5 minutes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Worksheet Functions | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) | |||
Threaded Mode
