calls per hour graph

[DerekA]

I have time stamped data for a complete month in a single column as such "1/1/2010 3:10 PM". I'm trying to break it down so that I can put it in a graph format showing me the activity for monday - sunday over a 24hour period in 30minute intervals.

I'm trying to do it via a pivot table, but while I can get it to show me the legend for the weekdays and the hours on the X-axis I can't seem to get it to break down to show the number of calls per half hour.

Any advice would be greatly appreciated

 

[AlphaFrog]

This will round the date-time value in cell A1 to the half-hour.

=FLOOR(A1,1/48)

Put this formula in a new column for each date-time you want to round and then include this new column as field in your pivot table.