Summarizing by Time

  • Thread starter Thread starter ChrisW
  • Start date Start date
C

ChrisW

Hello,

My data is a table of times, server names, and error counts. The time
stamps are by the second. I need to chart this as a summary of total
errors in 15-minute intervals. Then, I would like if at all possible
for the chart time to list only the hours. Any ideas on to do this?

Thanks in advance,

ChrisW
 
I'd probably create a histogram of the data somehow. You can use the
Histogram feature of Data Analysis Toolpak, but you'll need to install the
toolpak.

Another way would be to create a helper column and round the data up or down
to the nearest 15 minutes and then use a pivot table to get the information
you need.
 
Back
Top