countifs
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
|