Calculating relative productivity percentage with 3 variables?
Posted on 2014-10-22
I am having some difficulty coming up with an Excel algorithm that will successfully calculate a relative productivity percentage.
If I have a raw product that weighs 90 and 3 people can process this product in 1 hour and 15 min, I want this to be a perfect score of 100% productivity. The calculation doesn't need to result in exactly 100%.
If the same weight (the unit is unimportant) can be processed in less than 1 hour and 15 minutes, it is acceptable for the result to be greater than 100%. On the other hand, if the product is completed in greater than the aforementioned time, the productivity will become accordingly lower than 100%.
Both the product weight and the number of people will also vary.
Finally, which cell format do I use in order to input unit time in the form of 1.59 (for 1 hour and 59 minutes)?
Thanks so much!