Add up the time lost to every unplanned stop.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Unplanned downtime
—
Unplanned downtime
—
Number of stops
—
Formula
Sum of the time lost to unplanned stops
=SUM(B2:B20)Excel: Length of each unplanned stop: one per cell down column B
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.