G
Guest
How do I calculate how long it takes to complete processing parts when the
number of parts to process changes. For example I am using the following to
track time
A B C D
E
1 Code Description Hours Code Factor
2 10 IL MTL ISSUE 0.50 10 0.02
3 20 IL COAT 0.50 20 0.02
The formula in Cell E2&E3 is=TIME(0,30,0). The Hours in colum C are based on
processing 10 parts. My question is how do I increase the factor in the E
colum to account for the increased time required to process 20 parts.
Thanks
Scott
number of parts to process changes. For example I am using the following to
track time
A B C D
E
1 Code Description Hours Code Factor
2 10 IL MTL ISSUE 0.50 10 0.02
3 20 IL COAT 0.50 20 0.02
The formula in Cell E2&E3 is=TIME(0,30,0). The Hours in colum C are based on
processing 10 parts. My question is how do I increase the factor in the E
colum to account for the increased time required to process 20 parts.
Thanks
Scott