Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-04-2016, 01:10 PM
gebobs gebobs is offline filtering a list based clock time Windows 7 64bit filtering a list based clock time Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Why are Date and Time separate? Is the data imported from a logger or something? If you combine them, you should be able to filter right down to the date and minute with the canned filters. For whatever reason, filtering by time alone does not give this capability.

See the attached. Select the filter above Date/Time and you will see that I have filtered for Today from 1:27 pm through 1:29 pm.
Attached Files
File Type: xlsx TimeFilter.xlsx (49.6 KB, 13 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering a list based clock time VBA: Replacement of words based on a list roderh Excel Programming 2 09-06-2015 08:54 PM
Automatically Delete Slides based on current time Pacman52 PowerPoint 2 07-16-2015 05:30 AM
filtering a list based clock time Vba macro code for grouping the data based on 2 hours time dharani suresh Excel Programming 5 04-29-2014 03:25 AM
Looking for an add-in or a way to send automatic replies based off a list brady Outlook 0 04-19-2013 01:21 PM
filtering a list based clock time field value based on time of day akraw Word 3 03-26-2011 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft