Formula · Calculator

Operator efficiency formula

Operator efficiency = standard minutes earned ÷ minutes available. How to work it out, why stops that aren't the operator's fault must come out first, the Excel formula, and a calculator.

Updated · By Dev Hadvani, Founder of OpeEye

Short answer

Operator efficiency = (good pieces × standard time per piece) ÷ minutes available × 100. Minutes available are the time at work minus planned breaks and minus stops that were not the operator’s fault. 360 good pieces at 60 seconds earn 360 minutes; over 405 available minutes that is 88.9%.

The formula

Operator efficiency formulas, worked on the default example
StepFormulaExample
Standard minutes earnedGood pieces × standard time per piece360 × 60 s = 360 min
Minutes availableTime at work − planned breaks − stops not the operator's fault480 − 30 − 45 = 405 min
Operator efficiencyEarned ÷ available × 100360 ÷ 405 = 88.9%

Operator efficiency calculator

Change any number; the result updates as you type. The defaults are one operator on one shift.

Operator efficiency

88.9%

Standard minutes earned ÷ minutes available: 360 ÷ 405.

Standard minutes earned
360
360 pcs × 60 s
Without excluding stops
80.0%
What the operator is blamed for if you don't

Making operator efficiency fair

The same shift, two answers: 88.9% with the 45 minutes of breakdown and waiting for material taken out, 80.0% with them left in. The second number blames the operator for the maintenance team and the store — and operators who are blamed for things they can’t control stop writing stops down at all.

  • Take out: breakdowns, waiting for material, power cuts, waiting for inspection or a setter, no job assigned.
  • Keep in: unexplained stops, slow cycles, long tea breaks — the time the operator controls.
  • Only good pieces earn time. Rejects go in the rejection report with their reason, because many are the tool’s or the material’s fault.

This only works if every stop has a reason. That is why OpeEye asks the operator “why?” on the tablet for every stop longer than a few minutes: a stop with a reason that isn’t theirs doesn’t count against them; an unexplained one does.

Operator efficiency in Excel

Operator efficiency formulas in Excel
CellHoldsFormula
B2Good pieces360
C2Standard time / piece (sec)60
D2Time at work (min)480
E2Planned breaks (min)30
F2Stops not the operator's fault (min)45
G2Standard minutes earned=B2*C2/60
H2Minutes available=D2-E2-F2
I2Operator efficiency=G2/H2 (format as %)
WeekEfficiency for the week=SUM(G2:G7)/SUM(H2:H7)

Operator efficiency vs machine efficiency

Operator and machine efficiency compared
Operator efficiencyMachine efficiency (OEE)
MeasuresThe person against standard timeThe machine against its ideal cycle
Time baseTime at work the operator could producePlanned production time of the machine
RejectsEarn no timeReduce the quality factor
Use it forTraining, fair piece-rate, staffingFinding stops, slow cycles and scrap on a machine

For the machine side, see the OEE calculator and the machine utilization formula.

What an operator efficiency report should show

  • Each operator’s efficiency per shift and per job, with the minutes taken out shown, so nobody argues about the number.
  • The same operator on the same job week on week — the trend shows training working, or not.
  • Unexplained stop minutes per operator, as their own column: the part they can fix.

OpeEye builds this from the operators’ own taps on the tablet — PIN login, pieces, rejects and the reason for every stop — at ₹399 per machine a month, with unlimited users.

Efficiency your operators agree with.

Every stop has a reason, so stops that aren't the operator's fault come out automatically. Free 15-day trial.

Questions shop owners ask

What is the operator efficiency formula?

+

Operator efficiency = standard minutes earned ÷ minutes available × 100, where standard minutes earned = good pieces × standard time per piece. 360 good pieces at 60 seconds each earn 360 standard minutes; with 405 minutes available, efficiency is 88.9%.

What time should be taken out before calculating operator efficiency?

+

Planned breaks, and every stop that was not the operator's doing: breakdowns, waiting for material, power cuts, waiting for inspection. Leave them in and the same operator scores 80.0% instead of 88.9% — blamed for the store and the maintenance team.

Should rejected pieces count in operator efficiency?

+

No. Only good pieces earn standard time; a rejected piece used the time and produced nothing. Track rejects separately with their reason, because many are caused by the tool, the setup or the material rather than the operator.

What is a good operator efficiency?

+

Around 100% means the operator worked at the standard pace for all the time available; consistently above 100% usually means the standard time is too loose, and well below means either the standard is too tight or time is being lost. The trend for one operator on one job says more than a single number.

What is the difference between operator efficiency and machine efficiency?

+

Operator efficiency measures the person against standard time for the time they could work. Machine efficiency (or OEE) measures the machine against its ideal cycle for its planned time. One operator running two machines can be 100% efficient while each machine waits; one machine can be fully loaded while its operator waits for a setter.

How do I calculate operator efficiency in Excel?

+

With good pieces in B2, standard seconds per piece in C2, attendance minutes in D2, breaks in E2 and stops not the operator's fault in F2: =(B2*C2/60)/(D2-E2-F2), formatted as a percentage. For a week, divide the sum of earned minutes by the sum of available minutes.

Related