Hi,

Since you are using 2007 try this

=COUNTIFS(A1:A4,"="&9/24,A1:A4,"<="&17/24)

and add your other condtions
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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