Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
Reply



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 06:33 AM.


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