ExcelBanter - filter rows based on text time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filter rows based on text time (https://www.excelbanter.com/excel-discussion-misc-queries/201599-filter-rows-based-text-time.html)

Dabbler

filter rows based on text time

How do I filter to only display rows between 7:00pm and 9:00pm when the time
column is a text string that looks like:

11:49am
7:15pm
12:00am

Thanks for any suggestions?

Michael
Excel lightweight ;)

Sheeloo

filter rows based on text time

Conert the range to time format then filter between two values...

"Dabbler" wrote:

How do I filter to only display rows between 7:00pm and 9:00pm when the time
column is a text string that looks like:

11:49am
7:15pm
12:00am

Thanks for any suggestions?

Michael
Excel lightweight ;)

All times are GMT +1. The time now is 06:40 PM.