COUNTIF Time Range - Time Range provided in Cells

Hello,

I'm encountering a problem with a Formula. What I'm trying to do is Count within a specific time range, however the time range is provided by the user in two cells and can change at any time. If I type the specific time in the formula, for example =COUNTIF(P3:P162, ">05:00:00")-COUNTIF(P3:P162, ">05:59:00") it works great! But as soon as I do this.... =COUNTIF(P3:P162, ">A1")-COUNTIF(P3:P162, ">B1"), I get a zero. I was hoping this formula was going to work assuming that the user would put 05:00 in A1 and 05:59 in B1.

Any help would be greatly appreciated! Thanks!

Haha wow! awesome! That works.... I was playing around with something similar. What does the "&" sign do?

Thank you!

thank you again.... clearly learn something new everyday

Thanks for the help.