ExcelBanter - Pivot Table Grouping

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Grouping (https://www.excelbanter.com/excel-discussion-misc-queries/21446-pivot-table-grouping.html)

Darren

Pivot Table Grouping

Is there a way to group times i.e. 00:01 through 03:00 in a pivot table?

Debra Dalgleish

You could manually group the times. Or, in the source table, add a
column and lookup the start time for the group. Then, add that field to
the pivot table.

Darren wrote:
Is there a way to group times i.e. 00:01 through 03:00 in a pivot table?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 11:21 PM.