Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Filter the daily value at a specific hour

Filter the daily value at a specific hour

Filter the daily value at a specific hour

I have a table with water meter reads every 15 minutes in excel.

I want to filter the rows so that only the meter read at 2:00 shows every day. I have tried this using filter and it forces me to expand every day and select the hour. Is there shortcut to select only the 2:00 hour of each day in just a few clicks? As it stands now, I have to click to expand the daily filters before I can check off the hourly selection and it results in 100s of clicks to see a year of data showing only the 2:00 meter reads.


RE: Filter the daily value at a specific hour

Add a column that pulls only the hour from your (assumed) date+time column. Filter on the new column.

RE: Filter the daily value at a specific hour

Great idea. I will try that and report back...

RE: Filter the daily value at a specific hour

That worked... I used =TIME(HOUR(A1),MINUTE(A1), SECOND(A1))to extract the hour and minutes out of the date and time. Now it would be great if I could do a line graph that shows 12:00 each day for 7 days and then do the same for 1:00 and the same for 2:00, etc, etc and then superimpose the line graphs on top of each other. You got me most of the way there... Thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close