Filter by Time

D

duketter

Excel 2007 - I am trying to filter by time to show how many records are
between 6:00 AM and 6:00 PM. Here is the format of the record:

6:20:26 AM (hh:mm:ss) I have about 27,000 records and just want to show
how many are between 6am and 6pm. How can I do this? I have tried different
filters but they don't seem to be working for what I need. I keep getting
blanks.
 
G

Gary Keramidas

did you try applying an autofilter to the range and using the dropdowns to
filter the records on the time column?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate time worked based on start / end times & working hours 3
Determine if night shift by start & end time 2
Pivot table macro filter data between yesterday and today (date+time) 0
Grouping Time in Pivots. 2
date based query fails to find records in given period 8
date based query fails to find records in given period 3
Date and Time 4
How to do a formula counting the number of hours between 2 times? 2

Top