ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Ppmh (https://www.excelbanter.com/new-users-excel/448878-ppmh.html)

jolietjake

Ppmh
 
Can someone help me with the formula I need for tracking parts per man hour? My goal is 32 units produced in 8 hours with 6 people. I need a formula that adjusts based on number of employees and time worked that day. Thanks!

Claus Busch

Ppmh
 
Hi,

Am Thu, 13 Jun 2013 12:41:24 +0100 schrieb jolietjake:

Can someone help me with the formula I need for tracking parts per man
hour? My goal is 32 units produced in 8 hours with 6 people. I need a
formula that adjusts based on number of employees and time worked that
day. Thanks!


=32/8/6
=2/3 parts per man hour


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com