t83357
New member
I have created a pivot table which properly display the time of day and the number of calls at that time. (There happens to be only one call per minute but in theory there can be multiple calls made in the same minute). I have tried to sum the calls by hour using countif and a variety of other things. Any help would be appreciated! Below is an image of what I am trying to calculate and the sample excel sheet is also attached.