Hello All,
I am preparing a scorecard for 200 employees where the Resolve Per Hour (RPH) Target changed from 2.5 to 3.5 in middle of month. I need the help on calculating Production Efficiency % and achieved RPH when employees are working on different Resolve Per Hour target.
I have tried to use one formula but its giving an error.
I want to attach Excel file for reference, but I am unable to find any option to attach the file.
Please help me with this task.
I am preparing a scorecard for 200 employees where the Resolve Per Hour (RPH) Target changed from 2.5 to 3.5 in middle of month. I need the help on calculating Production Efficiency % and achieved RPH when employees are working on different Resolve Per Hour target.
I have tried to use one formula but its giving an error.
I want to attach Excel file for reference, but I am unable to find any option to attach the file.
Please help me with this task.