Customer Stats - Logging times of callers

  • Thread starter Thread starter ScottyG
  • Start date Start date
S

ScottyG

I have a spreadsheet that logs the time/name/enquiry/etc of Customers.

I need it to count the number of callers within each hourly period ie
9:00, 9:10, 9:20, 9:25 would be 4 callers etc, for statistical
analysis. I need to send this info to a graph showing volume of callers
over the day.

I am at my wits end - i am sure it is sooo simple. :confused:

Thanks
 
Dear Scotty

A pivot table may be the answer. Use the time of day as
the row field, and then group all of the calls into hourly
blocks.

Hope this helps

Paul
 
Back
Top