Thread: 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
> >
> >