Select Microsoft excel Time series Data

  citylim 07:01 16 Jul 03

Please help me how to select time series excel data. ie:
date time data
15/7/03 00:00:00 25.36
15/7/03 00:00:30 12.63
15/7/03 00:01:00 25.36
17/7/03 00:01:30 15.88
15/7/03 00:02:00 36.11
17/7/03 00:02:30 41.22
17/7/03 00:03:00 25.33
I will like to select the hourly data only. Please help me provide the function .

  recap 08:43 16 Jul 03

click here for a good guide to Excel functions.

  VoG II 12:50 16 Jul 03

There are probably several ways of doing this.

One way is to add an extra column and enter the formula


(assuming that your times are in Column B).

Copy this formula down as fat as necessary (hover the cursor over the bottom right of the cell until it turns into a + then hold down the left mouse button and drag down).

Assuming that the column you have just added is D, select all the cells in Column D, Data/Autofilter.

Click the arrow that is added to the top of Colunm D and select 0 from the list. This will hide all the rows that contain times that are not hourly.

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced