Counting Time

I have a database that exports out a search but the time field is a different format, which I believe it is text format. When I do a countifs for the rep and between a time range it returns 0, which I know is obviously wrong. What formula can I do in the countifs to actually count them when the criteria is a different format? Because if I do a TIMEVALUE formula in column T and do my range as that column it works fine. But I am wanting to do this as an ongoing basis and do not want to have to worry about filling down a column, or if this ends up as a coworker using this sheet, I want to make as easy and simple as possible. I have attached my sample data as well.

Highlight the data in column S, then click on Data | Text-to-columns, then on the first panel of the dialogue box click on Finish. That should convert the text values to proper times, so you don't need column T.

Hope this helps.

Pete

Thank you very much that worked perfectly!