VLOOUP time range

[db49ers]

I'm trying to count how many items have been sold each hour from a report. In example below between 10:00pm and 11:00pm I sold 4 items. I need to do this for each hour. How do I do a lookup for a time range? Thanks in advance!
TIME Items Sold
10:41:00 PM 2
2:42:00 PM 1
4:36:00 PM 1
8:02:00 PM 1
8:42:00 PM 1
10:07:00 PM 2
8:26:00 PM 1
2:06:00 PM 1
4:51:00 PM 1

 

[db49ers]

This driving me nuts. If I copy what you did to a blank sheet it works. However if I try it on the data I have it doesn't work. Not sure what I am doing wrong.

 

[db49ers]

So I believe I know why it is not working for me. The column has both date and time in it. I had formatted the cell to show time. Suggestions?
1/2/2019 12:46
1/2/2019 18:01
1/2/2019 20:36
1/3/2019 18:01
1/3/2019 22:09
1/5/2019 20:33
1/7/2019 21:33
1/8/2019 19:06
1/9/2019 13:13
1/9/2019 21:24
1/9/2019 21:53
1/10/2019 18:04
1/12/2019 21:36
1/13/2019 7:19

 

[db49ers]

I figured out how to split the column! WhooHoo! Thanks for pointing me in the right direction!