Are your times calculated (in which case there may be small rounding
errors)? The formula works fine for me if I enter 6:00 PM into a cell in
column C.

In article ,
NWO wrote:

Clarification of previous post...the below post is worded correctly with a
more relavant example...

I have the following array formula:
{=SUM((B$1:B$100=DATEVALUE("3/10/2007"))*((C$1:C$100)=TIMEVALUE("6:00
PM")))}. Formula yields a 0 count, even though there are several records in
the range. Conversely, when 6:00 AM is entered in place of 6:00 PM, then all
of the records that match the 6:00 AM criteria are counted - the same just
dosn't work when the time value is 6:00 PM - why? this is driving me nuts!!!

Thank you.

Mark :)