Pivot Table & Time

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
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
 
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.
 
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
 
Back
Top