View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default Pivot Table Grouping (Excel 2000)- This has to be simple

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