View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnUKMed JohnUKMed is offline
external usenet poster
 
Posts: 1
Default Excel Pivot Table Grouping

I have a sheet that shows how long reports take to print. Each report shows
start time in one column and another column shows how long it takes for it to
print. I can group in a pivot table and chart the average time for each
start time. IE at 8:30 5 reports print and average time is 2 min. I am able
to group by day, hour and min, but i want to group the min select in 5 or 10
min increments. IE 8:30, 8:34, and 8:35 data would be grouped togther
instead of as seperate times.

Is there a way do group min by time ranges?

Thanks,
--
John