I have a table where we track how long it takes to process a certain product.
I need to know how to average the number of product processed per day and
the percentage that are processed within 9 hours. Can anyone help me?

Tania

On 9 May, 22:09, TLAngelo wrote:
I have a table where we track how long it takes to process a certain product.
I need to know how to average the number of product processed per day and
the percentage that are processed within 9 hours. Can anyone help me?

Tania

Can you provide some more information - how are you capturing the
information?

e.g. is it a table, what are the columns, and some sample data:
Date..................Product..................Hrs
28Apr07 Widget 7
28Apr07 Fluff 2

Best

Andrew

It is a table, we track how long it takes to process each "widget" and now I
need to tell them an average of how many widgets are processed per day and
the percentage that were processed within the 9 hour requirement. Example:

Product Date In Time In Date Out Time Out Total Holding Time
Widget 04/30/07 9:30am 04/30/07 11:15am 1:45
Widget 04/30/07 4:00pm 05/01/07 8:30am 2.30

"loudfish" wrote:

On 9 May, 22:09, TLAngelo wrote:
I have a table where we track how long it takes to process a certain product.
I need to know how to average the number of product processed per day and
the percentage that are processed within 9 hours. Can anyone help me?

Tania

Can you provide some more information - how are you capturing the
information?

e.g. is it a table, what are the columns, and some sample data:
Date..................Product..................Hrs
28Apr07 Widget 7
28Apr07 Fluff 2

Best

Andrew

On 9 May, 22:37, TLAngelo wrote:
It is a table, we track how long it takes to process each "widget" and now I
need to tell them an average of how many widgets are processed per day and
the percentage that were processed within the 9 hour requirement. Example:

Product Date In Time In Date Out Time Out Total Holding Time
Widget 04/30/07 9:30am 04/30/07 11:15am 1:45
Widget 04/30/07 4:00pm 05/01/07 8:30am 2.30


If your Excel table if 6 columns Cols A - F, with 100 rows. The table
range is A1:F100.

1. Assuming you count a widget as "processed in the day" based on the
"Date Out".

In Cell C105, type in the date that you want to evaluate.
In Cell D105 type = COUNTIF($D$2:$D$200,C105)

You can put another date in C106, and copy the formula down to D106.

2. Assuming "percentage that were processed within the 9 hour
requirement" means
(Count of Rows where "Total Holding Time" < 9) / Count of all rows...
then

In Cell F105, type =(COUNTIF(C2:C100,"<9:00")/ COUNT(C2:C100)

The <9:00 may not work - this is supposed to mean < 9 hours, but it
depends on what format you have entered the time in.

HTH

Andrew