Drop your times into your Row fields and any cell into the data field.
right-click on a time and select "Group and Show Detail" and "Group". you
can then sort by Hours.

"GEM" wrote:

Thanks Bob.

For example, in my report I have times of all day. 8:10 PM, 7:00 AM, 5:42 PM
etc.

I want to group them, 1:00 AM - 8:00 AM, 8:00 AM - 5:00 PM, 5:00 PM - 12:00
AM, all in a pivot table...

1:00 AM - 8:00 AM ---- 1587 calls
8:00 AM - 5:00 PM ---- 10897 calls
5:00 PM - 12:00 AM ----- 568 calls

Something like this...

"Bob Phillips" wrote:

What do you mean by group? Do you mean just sort them, or do you mean sort
them and add row outlining?

--
__________________________________
HTH

Bob

"GEM" wrote in message
...
I have under column A times, for example
A1=3:45 PM
A2=4:48 PM
A3=7:12 AM
ETC...

How can I group these?? 1:00 AM - 1:59 AM, 2:00 AM - 2:59 AM etc...

Is this possible??