Need to get a count on an hourly basis
=SUMPRODUCT(--(HOUR(A1:A20)=11),--(B1:B20=--"2006-6-05"))
for 5th June
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Toppers" wrote in message
...
=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
|