Need to get a count on an hourly basis

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

=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

Wow. That worked like a charm. If you could give me an option within the
formula to include a date ... I would be eternally grateful to you. Thank you
for your help Toppers.

"Toppers" wrote:

>
>
> =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

=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" <[email protected]> wrote in message
news:[email protected]...
>
>
> =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