Published: Nov 18, 2026

Time Study in Manufacturing: Method, Example and Free Excel Template

    Time Study in Manufacturing: Method, Example and Free Excel Template

    A time study measures how long defined work elements take under recorded conditions. In manufacturing, it helps a team understand the work content behind a cycle, find delays and check whether an improvement changed the process.

    This guide uses a fictional automotive component assembly to explain observation boundaries, recording and interpretation. It also explains the calculation used in Ollo’s free Excel time study template. Measuring a task does not, by itself, establish an approved standard time.

    Time study and work sampling: different questions

    A time study records the duration of an operation or element, such as fitting a bracket. Work sampling records the activity observed at selected moments to estimate the proportion of time spent in different states. Use a time study to examine seconds per cycle; use work sampling to investigate broader activity proportions.

    Motion study examines how the work is performed. Combining time and motion observations helps explain a delay rather than simply labeling one operator as slow.

    What the free time study template contains

    ⬇ Download the free time study template

    Completed English time study Excel example included in the free template download

    The workbook has a completed Example sheet and a blank Time study sheet. Each form accommodates 15 work elements and 15 observations. Enter observed seconds in the blue-text cells, and keep information about the operation, observer, date and unusual events with the study.

    The example covers retrieving a part, installing a bracket and visually inspecting it. These are only part of a unit assembly process. Do not treat the example’s total as the time for every operation needed to make a complete unit.

    How to conduct a time study

    1. Define the objective and measurement conditions

    Choose a question that the result can answer: “Which elements account for variation in this bracket installation?” is more useful than “How fast is this operator?” Explain the purpose to the people involved and confirm the approved recording arrangements.

    Record three groups of conditions:

    • Scope: part number, operation, equipment and operator’s training status.

    • Boundaries: the observable event that starts and ends each element.

    • Operating conditions: supply method, tools, inspection requirements and interruptions.

    For example, start “retrieve part” when the hand begins moving toward the supply location and finish when the part is in the defined installation position. Use the same boundary for every observation.

    2. Break the work into recognizable elements

    Choose actions that can be observed consistently, such as retrieving the part, installing the bracket and inspecting the result. Avoid one long “assembly” element if the purpose is to locate a delay. Do not split actions so finely that the observer cannot identify the boundaries reliably.

    Record the measurement method. With continuous timing, element durations come from differences between successive readings. With a resetting stopwatch, each element is timed separately. When using video, retain timestamps so another reviewer can check the observation.

    3. Measure several cycles and retain unusual events

    The following observations are fictional and illustrate the method. Five cycles are not a general recommendation for an adequate sample size.

    Observation

    Retrieve part

    Install bracket

    Inspect

    Total

    1

    8 s

    12 s

    11 s

    31 s

    2

    9 s

    12 s

    10 s

    31 s

    3

    20 s

    12 s

    11 s

    43 s

    4

    8 s

    13 s

    10 s

    31 s

    5

    9 s

    12 s

    10 s

    31 s

    Observation 3 includes 12 seconds of searching for a part. Keep the original observation and the reason. Removing a long cycle without an explanation would hide a real problem. Where a separate normal-method calculation is needed, show both the inclusion rule and the excluded event.

    4. Calculate and interpret the results

    The average complete cycle in this example is 167 ÷ 5 = 33.4 seconds. The four cycles without the searching event each take 31 seconds. The difference directs attention to part presentation and identification; it does not prove that the operator should move faster.

    The template’s selected time (¼ range) uses a different calculation for each element:

    ROUND(minimum + (maximum − minimum) ÷ 4, 0)

    Only numeric entries are included. Entering an exceptional observation as text in parentheses, such as (20), excludes it from this selected-time calculation. Preserve its cause in the observation notes. This calculation is neither the arithmetic mean nor the statistical first quartile.

    The example’s selected values are 8, 12 and 10 seconds, totaling 30 seconds. That selected total differs from the observed cycle average because the methods answer different questions. Label the value used in a report or balance chart.

    5. Test a change and measure again

    If searching is the issue, try a defined change to the label orientation or supply position. Re-measure with comparable parts, boundaries and operating conditions. Check picking errors and physical effort as well as elapsed time.

    Keep the before and after records separate. A different product mix or a change in inspection requirements may explain a time difference even when the intended improvement had little effect.

    Ollo Factory manufacturing work analysis AI: request a brochure with features and use cases

    Observed time is not standard time

    An approved standard time may require an established method, performance rating and defined allowances under the organization’s work measurement procedure. A fast observation, a selected value or an AI-generated duration does not automatically satisfy those requirements.

    Machine time and manual time may overlap. Do not add both to an operator’s workload without checking the timeline. A standard work combination sheet helps examine manual work, walking and machine operation together.

    Common questions about time studies

    How many observations are necessary?

    The required number depends on variation, the purpose and the precision needed. Start with a pilot study, review the distribution and unusual events, and plan additional observations accordingly. A universal “five cycles is enough” rule is unreliable.

    Can video replace the stopwatch?

    Video allows repeated review of boundaries and events. Its usefulness depends on image quality, visibility, timestamps and appropriate handling of recorded information. It improves traceability but does not remove the need to define the study.

    Related reading:

    Summary: measure a defined method and explain the variation

    • Set consistent element boundaries and record the operating conditions.

    • Keep exceptional events and distinguish different calculation methods.

    • Re-measure changes and check quality, safety and total process performance.

    Video AI can reduce manual classification and time aggregation, leaving the team more time to investigate the reasons behind the numbers.

    Analyze work elements and cycle variation with Ollo Factory

    Ollo Factory analyzes manufacturing work videos and can classify actions using defined categories, aggregate time and visualize variation. For repetitive work, a reference cycle can be specified to detect additional cycles and inspect differences.

    Teams can compare reference and target work to locate delays and connect the findings with training or work instruction creation. Review category definitions and analysis results against the recorded video before using them in a production decision.

    Ollo Factory synchronized comparison of reference and trainee work videos

    Product screen published on Ollo’s English website. It illustrates the feature, not the results of the fictional assembly example in this article. Explore Ollo Factory features.

    About the author

    K.Y. | Business Development Lead & Marketing, Ollo Inc.

    K.Y. leads business development and marketing at Ollo Inc., an AI startup originating from the Matsuo Laboratory at the University of Tokyo and the developer of Ollo Factory, a work analysis AI for manufacturing.
    After studying engineering and design at university, K.Y. joined a major automaker and worked on new electric-vehicle development, from design through factory production, including hands-on assembly-line training. K.Y. later worked in sales and marketing at a manufacturing startup.
    Today, K.Y. helps manufacturing teams use AI to improve the way they work through Ollo Factory.

    Back to articles

    See how Ollo Factory can support your factory

    Book a demo

    • See the product in action
    • Discuss your production needs
    • Explore available plans

    Book a demo

    Request a brochure

    • Customer stories
    • Key features
    • How to get started

    Ollo Factory English product brochure