Removing-Filtering out Times

[jschoon4]

I have a "Time" Column with about 23,000 rows of assorted times and various other data in a particular row. I want to filter out rows with Times between 8:00:00 am to 5:00:00 pm. In Other words I don't want to see those rows. EXAMPLE:

Time

08:06:06 AM

12:00:00 AM

12:16:09 AM

12:20:07 AM

1:28:14 AM

1:37:47 PM

1:37:48 PM

2:24:51 AM

2:55:01 AM

3:43:34 AM

4:11:09 PM

4:16:36 PM

4:35:15 PM

4:41:31 PM

5:48:58 AM

<tbody>
</tbody><colgroup><col></colgroup>

 

[chrism216]

Times are assigned a value between 0 and 1,

so 8 AM would be = 8/24 = 0.3333
and 5 PM would be = 17/24 = 0.7083333

So try filtering between those two values.

Cheers

 

[jschoon4]

How would I write that formula?

 

[chrism216]

Just use an autofilter (CTRL + SHIFT + L) for the time column, select number filters -> between and use 0.3333333 for the lower bound and 0.7083333 for the upper bound.