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?
<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?