Pivot Table & Time
 

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

Pivot Table & Time
 

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

Pivot Table & Time
 

Thank you Debra

Your solution was a lot easier than what I was trying to do. I do have one
more question. How can I set up a pivot point table to tell me which day
had the most unsuccessful batches?

Dominique

"Debra Dalgleish" wrote in message
...
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