Skip to content
IoTronix Solution

Downtime Tracking Excel Template: Free Columns and Formula

Published · 7 min read · IoTronix Solution

In short

A downtime log in Excel needs one row for each stop. Each row has the date, machine, stop time, restart time, minutes down, a reason code and who reported it. You can copy the column layout below for free. Excel works until entries come in late, or only one person keeps the file. At that point, a machine downtime tracker that records stops by itself is worth the money.

The columns a downtime log needs

A downtime log needs one row per stop and ten columns: date, shift, machine, stop time, restart time, minutes down, reason code, what happened, reported by and fixed by. Most factory downtime sheets fail for one reason. They record that a machine stopped, but not when it restarted or why. Without these two facts, you cannot add up the hours lost. You also cannot see which cause to fix first.

Set up one row per stop, not one row per machine per day. Copy this layout into a new Excel sheet. This is the whole free template.

ColumnHeaderWhat goes in itExample
ADateDay the stop started17/11/2026
BShiftA, B or CB
CMachineMachine number as painted on the floorIM-07
DStop timeTime the machine stopped (hh:mm)14:20
ERestart timeTime it ran good parts again (hh:mm)15:05
FMinutes downFormula: =MOD(E2-D2,1)*144045
GReason codePick from a drop-down list, never free textBD-MECH
HWhat happenedOne line from the operator or technicianEjector pin broken
IReported byName of the person who logged itAhmad
JFixed byTechnician who restarted itKumar

The MOD formula in column F works for stops that go past midnight on the night shift. Excel stores time as a fraction of a day, and 1,440 is the number of minutes in a day, so the result comes out in minutes.

Make column G a drop-down list so every entry uses the same code: on the Data tab, choose Data Validation, set Allow to List and point the Source at your list of codes [4]. Free text spoils the report, because "mould problem", "mold prob" and "mould" count as three different reasons.

Common reason codes

Use eight to twelve reason codes. Keep planned stops (setup, preventive maintenance, no order) separate from unplanned stops (breakdowns, waiting for the technician, no material, QC hold, no operator). Planned stops are part of the schedule. Unplanned stops are the ones that cost you output you had promised a customer.

CodeMeaningPlanned or unplanned
BD-MECHMechanical breakdown: bearing, pin, belt, hydraulicsUnplanned
BD-ELECElectrical fault: heater band, sensor, motor, tripUnplanned
WAIT-TECHMachine down, waiting for the technician to arriveUnplanned
NO-MATNo material, resin not dried, coil not deliveredUnplanned
QC-HOLDStopped by QC for rejects or a dimension problemUnplanned
NO-OPNo operator on the machineUnplanned
SETUPMould, die or product changeoverPlanned
PMPreventive maintenance on schedulePlanned
NO-ORDERNo job scheduled for this machinePlanned

WAIT-TECH needs its own code. In many factories, the repair takes 15 minutes, but finding the technician takes longer. One BD code for everything does not show this.

Once a month, sort by reason code and add up column F. The top two codes usually make up most of the hours. Those are your first fixes. If you also track OEE, these minutes feed straight into availability, which is operating time divided by scheduled time [2].

Where Excel fails

Excel fails because of how people use it, not because of the formula. Entries come in late. Only one person keeps the file. Breakdowns stay in WhatsApp. And nobody sees a stop while it is happening.

  • Late entries. Operators write stops on paper and someone types them in at the end of the shift or the next morning. Stop and restart times become guesses, and short stops of a few minutes are never written down at all.
  • Only one person keeps the file. The sheet is on one PC or a shared drive. Two people can edit the same workbook at once only when it is stored on OneDrive or SharePoint Online [3], so in most factories one clerk keeps it, and when she is on leave nobody updates it.
  • Breakdowns are reported on WhatsApp. The operator sends a photo to the maintenance group. The technician replies "OTW". The stop time in the sheet becomes the time someone read the message, and many of those stops never reach the sheet.
  • No live view. The owner sees yesterday's downtime, at best. When an extrusion line has been down for 35 minutes right now, the sheet cannot tell anyone.

None of this is the clerk's fault. A spreadsheet only knows what someone types into it. On a busy production floor, people type late, round off times and forget.

What a machine downtime tracker adds

A machine downtime tracker gets the stop and restart times from the machine itself, not from someone's memory. In FactoryOS, a sensor reads run and stop, motor current or cycle count. When the machine stops, a breakdown report opens itself and the technician gets it on his phone straight away.

The operator's only job is to pick the reason code on a tablet or phone. Minutes down, machine number and time are already filled in. It has the same columns as your Excel sheet, but nobody has to type them.

Three FactoryOS Apps share that stop data:

  • Breakdown Reporting: opens a report when a machine stops, tracks who responded and when it restarted.
  • Maintenance Scheduling: plans preventive work and shows which machines keep having the same fault.
  • OEE Tracker: turns run time, stop time and machine counts into availability, performance and quality per machine and per shift.

It works on old machines. Where the controller can be read, we read it. Where it cannot, we clip on our own sensors, so the machine needs no data port and nothing changes in how it runs. An old hydraulic press with no data port can report its own stops.

Excel logMachine downtime tracker
Stop and restart timeTyped in later, often roundedRecorded by the machine
Short stopsUsually missedCaptured
Who sees itWhoever opens the fileOwner, manager and technician on their phones
When the clerk is on leaveNobody updates itKeeps running
Breakdown alertWhatsApp groupReport opens itself, sent to the technician

What downtime costs your factory in RM

RM lost per month = machines × hours stopped per week × 4.3 × RM per machine-hour. Here, 4.3 is the average number of weeks in a month. Our downtime calculator needs only those three numbers: how many machines, how many hours each stops per week, and the output value of one machine-hour in RM.

Example figures only: a plant with 12 injection moulders, each stopped 3 hours a week, with output worth RM150 per machine-hour, loses 12 × 3 × 4.3 × RM150 = RM23,220 a month. Put in your own numbers. If you do not know the hours per week, that is the first thing the Excel log above will tell you.

Siemens' study The True Cost of Downtime 2024 estimates that unplanned downtime costs the world's 500 biggest companies 11% of their revenues, close to $1.4 trillion a year [1]. It found an average large plant still loses 27 hours a month to unplanned downtime [1]. Those are figures for the largest companies in the world, not a Malaysian SME and not a FactoryOS result, but they show why the hours are worth counting.

Which one to start with

Start with Excel on your two or three worst machines. Move them to a tracker when the sheet is often late, or when the stops in it do not match the stops in WhatsApp.

  1. Start the Excel log this week on your two or three worst machines. Use the drop-down reason codes from day one.
  2. After a month, add up minutes by reason code and run the result through the downtime calculator.
  3. If the sheet is often late, or the stops on WhatsApp do not match the stops in Excel, move those machines to a tracker that records stops by itself.

Find out what causes your downtime hours

Bring your downtime log, even a messy one. We visit for 30 minutes and show you your 3 most time-wasting processes. We reply within 1 working day.

Questions

Is there a free downtime tracking Excel template?

Yes. Copy the ten columns in the table above into a new sheet. Use =MOD(E2-D2,1)*1440 for minutes down. Make the reason code column a drop-down list with Data Validation [4].

How do I calculate downtime minutes in Excel?

Subtract the stop time from the restart time and multiply by 1,440, the number of minutes in a day. Put it inside MOD(restart minus stop, 1), so stops that go past midnight are still correct.

What is a machine downtime tracker?

It is a system that gets each machine's stop and restart times from the machine itself. The operator only has to give the reason. In FactoryOS, a breakdown report opens by itself when a machine stops, and goes to the technician's phone.

Can I track downtime on old machines without a PLC?

Yes. We clip our own sensors onto the machine to read run and stop, motor current or cycle count. No data port is needed. Some people call this an IoT setup. For you, it means the old machine reports its own stops.

What downtime reason codes should I use?

Use eight to twelve codes, and keep planned and unplanned stops separate. Typical codes are mechanical and electrical breakdown, waiting for the technician, no material, QC hold, no operator, setup, preventive maintenance and no order.

How much does machine downtime cost?

Siemens estimates that unplanned downtime costs the world's 500 biggest companies 11% of revenue [1]. For your own factory, multiply machines × hours stopped per week × 4.3 × output value per machine-hour.

Sources

  1. [1]Siemens (Senseye Predictive Maintenance). The True Cost of Downtime 2024
  2. [2]Wikipedia. Overall equipment effectiveness
  3. [3]Microsoft Support. Collaborate on Excel workbooks at the same time with co-authoring
  4. [4]Microsoft Support. Create a drop-down list