Hi All

I use Excel 2003.

I have a set of data in columns in a spreadsheet that reflects sets of phone
calls.

The columns are (User ID; Name; Date; Start time; End Time; Call Length;
Hold Length; Talk Time; and Wrap Time).

I currently have vba code that shows averages of the Call Length, talk time
and wrap time with date as a page item and name as a row item.

I now want to add something that shows these averages over parts of the day,
hour by hour during the opening hours. Is their a way to group certain start
times that fall between set times with just the pivot table functionality or
would I need to use some code or formulas to add an extra column to look at
the start times and give a time or name to indicate what part of the day that
call is in then use a pivot table.

Alternatively would I be best to forget pivot tables and set up a table
using array formula's to do what I want.

--
Regards and Thanks for any assistance.

Francis Brown.