Time Grouping in Pivot Table

HelpinMA

New Member
Joined
Mar 16, 2010
Messages
1
I have a pivot table that is looking at data 17k rows of data and in each row I have a value that corresponds to a time lag between two values. My time lag is in hh:mm:ss and ranges from 00:00:00 to 2137:16:14. I am trying to create a custom grouping of the time in a pivot table so I can show roll-up all the data by:
<00:04:59
00:05:00 to 23:59:59
24:00:00 to 47:59:59
ect...

can anyone help or have other solutions?
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,118,994
Messages
5,575,430
Members
412,664
Latest member
akilah03
Top