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.