You can use sumproduct

=SUMPRODUCT((A1:A23=TIME(9,0,0))*(A1:A23<=TIME(17 ,0,0)))

Mike

"JRD" wrote:

Is there a way in which I can use countifs function to count cells that
contain a time between 09:00 and 17:00?

If not is there any other function I can use for this

Thanks

John