Count cells in a range

Hello, I need to count how many values in a range of hours, something like this

Please Login or Register  to view this content.

The H column goes like

Please Login or Register  to view this content.

This is time and date on seconds (GPS time)

The problem is, if my formula is comparing the cell like the first formula I posted the return is "0", but if I make this

Please Login or Register  to view this content.

The thing works. But I dont want to type manualy the values. Is the anything I can do?

You need to have cell refs follow an '&'. Like this

=COUNTIFS($C$2:$C$6972;">="&H6;$C$2:$C$6972;"<="&H7)

Thanks a lot!

You're welcome.