Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table and grouping | Excel Discussion (Misc queries) | |||
Grouping in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping (Excel 2000)- This has to be simple | Excel Discussion (Misc queries) | |||
Grouping in Excel on a Pivot table, need to be able to retrive ex. | Excel Discussion (Misc queries) |