Summarizing by Time
 

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.

"ChrisW" wrote:

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

Ok. I'll give it a shot. How do I round times to the nearest 15
minutes?

Barb Reinhardt wrote:
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.

"ChrisW" wrote:

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