You could add a column to the data table, and calculate the time
groupings there.

Create a lookup table with the categories, e.g.:

0 Before 10
9:59 10:00 - 3:00
15:01 After 3:00

In the data table, use a VLOOKUP formula:

=VLOOKUP(D2,TimeLookup,2)

where the Time is in cell D2, and the time lookup table is named TimeLookup.

Include this field in the PivotTable, and the records will be grouped by
time category.


Dominique Feteau wrote:
I have a simple table that has 4 columns:

Day Date Who Time Successful

I have about 300 rows of data. What I want to do is use a pivot table to
get the information I need, but I'm not sure how to have it count between a
range of time.

To be more specific, I can make a count of successful and unsuccessful
records per day, but now i need to break it down further and find out how
many records were successful and unsuccessful before 10, between 10 and 3,
and after 3 (i dont need this total to be per day).

Any help is appreciated.

Dominique




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