Count function applied to a time period

  • Thread starter Thread starter MIchel Khennafi
  • Start date Start date
M

MIchel Khennafi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting periods Excel 1
Problem formatting dates from CSV file 2
using a time format in a count function 1
Count Employee Work Time - Don't Count Duplicates 3
Workday Formula to include date 0
Sum quantities per hour from inconsistent intervals on a 24hr cloc 4
Calculating Time? 2
Excel Facetime Measurement 1

Back
Top