Short answer
The formula
| Step | Formula | Example |
|---|---|---|
| Standard minutes earned | Good pieces × standard time per piece | 360 × 60 s = 360 min |
| Minutes available | Time at work − planned breaks − stops not the operator's fault | 480 − 30 − 45 = 405 min |
| Operator efficiency | Earned ÷ available × 100 | 360 ÷ 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
| Cell | Holds | Formula |
|---|---|---|
| B2 | Good pieces | 360 |
| C2 | Standard time / piece (sec) | 60 |
| D2 | Time at work (min) | 480 |
| E2 | Planned breaks (min) | 30 |
| F2 | Stops not the operator's fault (min) | 45 |
| G2 | Standard minutes earned | =B2*C2/60 |
| H2 | Minutes available | =D2-E2-F2 |
| I2 | Operator efficiency | =G2/H2 (format as %) |
| Week | Efficiency for the week | =SUM(G2:G7)/SUM(H2:H7) |
Operator efficiency vs machine efficiency
| Operator efficiency | Machine efficiency (OEE) | |
|---|---|---|
| Measures | The person against standard time | The machine against its ideal cycle |
| Time base | Time at work the operator could produce | Planned production time of the machine |
| Rejects | Earn no time | Reduce the quality factor |
| Use it for | Training, fair piece-rate, staffing | Finding 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
- Machine utilization formulaThe formula, planned vs calendar time, and a calculator.
- OEE calculatorFive numbers from one shift in, OEE and its three factors out. No sign-up.
- Rejection report formatRejects by reason, by count and by cost — daily and monthly.
- Production trackingPieces vs target per machine, operator, shift and job — without registers.