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
|