View Single Post
 
Old 12-30-2015, 04:24 PM
DPD16 DPD16 is offline Windows 7 64bit Office 2007
Novice
 
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