If you can provide more detail maybe we can figure out what the problem is.
My first guess would be that your entries aren't true Excel date/times but
are instead TEXT strings.

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Interesting that all three approaches gave vastly different results, with
none of them being correct. I thank you all for the help but will go a
different route.

"RoadKill" wrote:

Okay, so I have a new CountIf dilema. Will it work for a time field?

My date/time field looks like this: 5/6/2009 12:01:00 AM.

Is there any way to count the 12:00 - 12:59 entries? There could be
hundreds. All will be of the same date.

My range is A2:A10000.

Thanks for your help.