Average calls per hour per day

I have approximately a month's worth of data from our telephone system and would like to calculate the average number of calls per hour per day preferably in a pivot table and then graph it. I would therefore like to display the average number of calls say between 9 - 10am on a Monday and so on. The first few lines of data are as follows (apologies about the formatting, I am a newbie here):


Call type Date Time Source Duration
ans 31/07/2012 17:14:55 Line 9.1 00:00:40
out 31/07/2012 17:07:12 Jean 00:00:28
internal 31/07/2012 17:02:39 Kevin 00:00:10
ans 31/07/2012 16:53:26 Line 9.2 00:00:45
out 31/07/2012 16:53:04 Kevin 00:00:07
out 31/07/2012 16:52:41 Kevin 00:00:08

I can work out total volume of calls at a given time and the weekday for each date but I am really struggling on the quickest way to work out how to do the averages. So if there are 3 calls between 17:00 & 18:00 on Tuesday 31st July and then 4, 7 and 6 calls on the subsequent Tuesdays, the average is 5 in that time period on Tuesday. How do I get to that from the kind of data I have?

Thanks in advance for your help

Hello AmoraB,

Is this what you have in mind