Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-30-2015, 06:54 AM
DPD16 DPD16 is offline Filter by Time Windows 7 64bit Filter by Time Office 2007
Novice
Filter by Time
 
Join Date: Dec 2015
Posts: 8
DPD16 is on a distinguished road
Cool Filter by 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
Filter by Time Time Stamps automatically changed to same time! hydrogyny Word 4 02-09-2015 08:57 PM
Filter by Time date & time of last time a recent file was used pgeorgilas Word 1 10-31-2014 08:59 AM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Filter by Time Mail time--time zone? markg2 Outlook 3 09-18-2012 04:32 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 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