Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-30-2015, 04:24 PM
DPD16 DPD16 is offline filtering a list based clock time Windows 7 64bit filtering a list based clock time Office 2007
Novice
filtering a list based clock time
 
Join Date: Dec 2015
Posts: 8
DPD16 is on a distinguished road
Default filtering a list based clock time

Thank you in advance for the help:

Here is the scene, a spread sheet, contains 5 columns, many rows as follows:
Col 1 - Date
Col - 2- Clock time i.e....02:25:45
Col -3 - GPM
Col - 4 - W/L
Col - 5 Data

What I need to do:
I would like to be able to filter the data by the time row, where I can eliminate all rows that do not equal my criteria.

I used to have a formula that was given to me years ago (which I have lost) that went something like this:

select all the data >data>filter>text filter>does not equal......... this is where I lost it. I need to be able to filter the "time" column by a selected minute , say I only want to filter the data by 5 minutes, or 10 minutes.



Thanks again everyone for the help
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 04:26 AM.


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