=SUMPRODUCT(--(HOUR(A1:A20)=11))

will count orders received between 11:00 and 11:59

Does this help?



"Arun2902" wrote:

Hi All,

Need help with getting the count of the number of orders that were submitted
on an hourly basis. For example: Col A has the name of the vendor, Col B has
the Date and Col C has the Time when the order was placed. I need help in
counting the number of orders that were received in a particular hour.

Appreciate any help with this.

Arun