Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Sum and Count Function | Excel Worksheet Functions |