Pivot Table & Time

D

Dominique Feteau

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
 
D

Debra Dalgleish

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.
 
D

Dominique Feteau

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
 
Top