Working out Calls Per Hour. 8 Hour Day.

Hi there, I'm trying to implement a system were I can do some analysis on my call center staff. I want to be able to find out how many calls a day they are making and with this information create a chart to detail a person's performance for that day.

I have tried to create a pivot table but I'm not sure whether or not this is the best way of doing this?

I have attached an example of one of my staff's call logs for last Friday's work.

I'm also unsure on how to group the data too, in the future I will want to find out how many calls are being made between certain time frames, ie 09:00:00 - 10:00:00.

Thank you.

Please see attached file with PivotTable and Chart.

Thank you that's perfect! +REP. Would it be possible for you to explain how you did this in simple terms? I will need to replicate this for other members of my staff and for future employees.

Originally Posted by sturmy

Thank you that's perfect! +REP. Would it be possible for you to explain how you did this in simple terms? I will need to replicate this for other members of my staff and for future employees.

Sure, create a pivot table by go to Insert and select PivotTable, then go to Design (on the Ribbon), Report Layout and choose Show in Tabular Form. to see how pivot table is arranged click anywhere within pivot table then go to Options (located on the Ribbon) and click on Field List and while you there click on the Date filed and on the Ribbon click Group Field and unselect averything and select Hours.