Generate meaningful graph for times of day in Excel?

"Create a new column called ""Time of Day"" with this formula (assuming mod times start in A5):

=MROUND(A5-INT(A5),TIME(0,10,0))

(Why doesn't Excel have a FRAC function?)

This rounds the times to 10 minute intervals. You can change that to some other value (e.g. 5 or 15). Copy the formula to all rows.

Select the whole sheet and do a sort on the new column.

Now select the cells of the new column and do a subtotal, choosing ""count"" as the function. You can probably leave the other settings the way they are.

Now, on the left side of the sheet you'll see outline markers. Click on the second column. This should collapse the sheet to show only the counts. You can do a search and replace to make the column that the subtotal operation creates have text that you like. I replaced ""Count"" with nothing and it left just the times (which will become the X-axis labels).

Now select the count column and the Time of Day column, omitting the grand total at the bottom, and create a column chart.

I'm using Excel 2007, so I'm not being more detailed in my instructions since the user interface is so different from Excel 2002, but hopefully this will get you started."