Hello, I need to count how many values in a range of hours, something like this
=COUNTIFS($C$2:$C$6972;">=H6";$C$2:$C$6972;"<=H7")
The H column goes like

1019893815
1019895015
1019896215
1019898015
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
=CONT.SES($C$2:$C$6972;">=1019893815";$C$2:$C$6972;"<=1019895015")
The thing works. But I dont want to type manualy the values. Is the anything I can do?