#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Stamps automatically changed to same time! | hydrogyny | Word | 4 | 02-09-2015 08:57 PM |
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 |
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 |