How to count the number of rows by condition?

Question

excel

Good afternoon.
I have a table with many values.
Values ​​like:
10:00:01
10:00:23
11:00:01
12:00:02
...

That is the time.
It is necessary to count the number of records in a certain interval, for example, from 10:00:00 to 11:00:00.
I tried to do it using the COUNTIFS formula - it doesn't work. Did 2 conditions on 1 and the same column.

Answer 1

Use the array formula :
{=SUM(IF(HOUR(A1:A4)=10;1;0))}