I think this way you will still group by minute.

If you use FLOOR(MINUTE(A2)/10) it will retur0 for the minutes 0 to 9; 1 for
the minutes 10 to 19 and so on. Run your pivot table grouping for this column
and your data will be sorted by ten minutes interval.

If your sample is more than one hour long you may want to do:
CONCATENATE(HOUR(A2);":";FLOOR(MINUTE(A2)/10)) instead as yor grouping column

"Debra Dalgleish" escreveu:

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