Embroidery: Machine Run Time From Stitches

Excel Formulas › Embroidery

All versions

Stitch count is the honest measure of an embroidery job — it drives both price and time. Divide the stitches by your machine's stitches-per-minute to know how long a single head will run each piece.


Quick formula: Stitch count divided by stitches-per-minute, rounded to a tenth of a minute:
=ROUND(B2/C2,1)

A 12,000-stitch back design at 800 stitches a minute runs 15.0 minutes a piece before hoop and trim time.

Functions used (tap for the full reference guide):

The example

Three designs, each with a stitch count and the machine speed it will run at.

ABCD
1DesignStitchesSPMMinutes
2Left chest800080010.0
3Back2500070035.7
4Cap600060010.0

The formula

Stitches over speed is minutes; round to a tenth to schedule against:

=ROUND(B2/C2,1) // stitch count / stitches-per-minute = run minutes

How it works

One division, one round:

  1. B2/C2 divides the stitch count by the machine's stitches-per-minute to get run minutes.
  2. ROUND(...,1) keeps it to a tenth of a minute, close enough to plan a production run.
  3. Speed drops on caps, metallic thread, and heavy fills — keep a realistic stitches-per-minute, not the machine's top rated speed.
  4. This is machine run time only; add hoop, trim, and color-change time separately for a true per-piece figure.

Multiply by the number of pieces (and divide by heads on a multi-head) to plan the whole order.

Try it: interactive demo

Interactive

Enter the stitch count and the machine's stitches-per-minute.

Variations

Whole order

Multiply the per-piece minutes by the number of pieces.

=ROUND(B2/C2,1)*50

Multi-head machine

Six heads stitch six pieces at once — divide the order time by heads.

=ROUND(B2/C2,1)*50/6

Pitfalls & errors

Do not use the machine's top rated speed. Real production speed on caps, small text, and metallic thread is well below the sticker number, and planning at the top rate overbooks the day.

Run time is not the whole job. Hooping, trimming jump stitches, and color changes add real minutes — track those separately so your quote covers labor, not just needle time.

Practice workbook

📊
Download the free Embroidery: Machine Run Time From Stitches practice workbook
Edit the yellow stitches and stitches-per-minute cells; the run time recalculates.

Frequently asked questions

Is machine run time the same as the time I should bill?
No. Run time is only the needle-down minutes. Hooping, trimming, thread changes, and setup all add labor that the stitch-count division does not capture, so bill on total handling time, not run time alone.
What stitches-per-minute should I use?
Use your real average for the garment type, not the machine's maximum. Flats run fast, but caps, fine lettering, and specialty threads force the speed down, and planning at the honest rate keeps the schedule accurate.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Embroidery: Stitch Count Price · Cycle Time vs Takt · Throughput Per Hour

Function references: ROUND