Customer Stats - Logging times of callers

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
 
P

Paul Falla

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
 
Top