Re-post...
 

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 :)

Re-post...
 

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

Excel couldn't possibly confuse 0600 and 01800
--
Stephen Nichols
Freight Management Services
Cole International


"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 :)

Re-post...
 

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 :)