You could add a column to your source data, with the formula:
=MINUTE(A2)
where Time is in column A.
Add the new field to your pivot table, and group on it.
uncoolfester wrote:
I want to count the number of events that occur in 10 minute increments over
a period of days. I can easily count count the number of events, but the
default is for each minute and I don't see any way to change it to 10 minute
increments? Is this possible? Any help is appreciated.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html