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?
 
D

David Biddulph

Autofilter
Custom/ is greater than or equal to/ 6:00 AM
And/ is less than or equal to/ 6:00 PM

Omit the "or equal to" as required
 

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
Amending meeting cancels all future meetings 0
Grouping Time in Pivots. 2
Pivot table with filter by time? 0
How to do a formula counting the number of hours between 2 times? 2
Calculate After hours 3
Automatic Emails sent to my Contact Groups by Microsoft 1

Top