Count function applied to a time period
 

Good Morning to all of you

Submitting a question about a count function...

I built a spreadsheet to log calls my customers are making... I log:
- the day of the call (March 31, 2006 for instance)
- The time of the day (10:05 AM for instance)

I would like to create a summary table where I have the day of the week and
the period (From 7:00 AM - to 8:00 AM, from 8:00 AM to 9:00 AM....)
What is the function I should use to determine the number of call per
period?

Has anyone done this before?

Regards

Michel

Count function applied to a time period
 

=SUMPRODUCT(--(a2:A200=--"2006-03-31"),--(B2:B200=--"07:00"),--(B2:B200<--"
08:00"))

counts all calls on 31st between 7 and 8 AM

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MIchel Khennafi" wrote in message
...
Good Morning to all of you

Submitting a question about a count function...

I built a spreadsheet to log calls my customers are making... I log:
- the day of the call (March 31, 2006 for instance)
- The time of the day (10:05 AM for instance)

I would like to create a summary table where I have the day of the week
and
the period (From 7:00 AM - to 8:00 AM, from 8:00 AM to 9:00 AM....)
What is the function I should use to determine the number of call per
period?

Has anyone done this before?

Regards

Michel