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
|