Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter date time data
I have a table containing 3000 data points of measurements which were
automatically recorded every 20 minutes. They are arranged in two columns: date time and measurement, e.g.: Column A B 31/05/2007 08:00 2.35 31/05/2007 08:20 2.34 31/05/2007 08:40 2.44 31/05/2007 09:00 2.33 31/05/2007 09:20 2.41 etc How can I filter these to only see the data recorded every hour on the hour? I have tried playing around with AutoFilter etc which only produced the first line of the data, and I can find no help anywhere. All replies in easy language please. Many thanks Zoe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter date time data
Create a helper column to extract the hour, =HOUR(A2), and filter by that
column -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Zoe" wrote in message ... I have a table containing 3000 data points of measurements which were automatically recorded every 20 minutes. They are arranged in two columns: date time and measurement, e.g.: Column A B 31/05/2007 08:00 2.35 31/05/2007 08:20 2.34 31/05/2007 08:40 2.44 31/05/2007 09:00 2.33 31/05/2007 09:20 2.41 etc How can I filter these to only see the data recorded every hour on the hour? I have tried playing around with AutoFilter etc which only produced the first line of the data, and I can find no help anywhere. All replies in easy language please. Many thanks Zoe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry date/time? | Excel Discussion (Misc queries) | |||
Filter call data by open date | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) | |||
Time "and" Date for data points | Charts and Charting in Excel |