Running into a TIME issue with countif

I’m trying to count how many of TIME on a column are in between a time period with this formula:

=COUNTIFS(Q2:Q100,">="&TIME(0,0,0),Q2:Q100,"<"&TIME(0,1,0))

Q2 : Q100 being time between 00:13:08 and 11:57:15. The time column is formatted to TIME 24h (00:00:00). The result of the formula is 0, but should be 7. Tried formatting in a few different TIME formatting: 12h 00:00 PM and all the others, but same result.

Also tired =COUNTIFS(Q2:Q100, ">=00:01", Q2:Q100, "<=01:00"), same result.

What’s the issue here.