Re-post...

[Guest]

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

 

[Guest]

Have you tried using 24HR, or is that an option.

Excel couldn't possibly confuse 0600 and 01800

 

[JE McGimpsey]

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.