How to Calculate Cycle Time in Excel – 7 Examples

Example 1 – Using a Simple Formula to Calculate the Cycle Time in Excel

The following dataset showcases tasks to be performed,  the start and end date. The formula to calculate the cycle time is: Cycle Time = End Date – Start Date.

STEPS:

• Select a cell for the cycle time. Here, E5.
• Enter the formula below.

D5 indicates the end date and C5 the start date.

• Press Enter.
• By clicking E5, the formula will show in the formula bar.

• Drag the Fill Handle to copy the formula.

The result is displayed in column E.

Read More: How to Calculate Elapsed Time in Excel

Example 2 – Cycle Time Calculation in Parts per Minute

The dataset below contains the tasks in column B, the parts of the tasks in column C, and the duration in minutes in column D. The formula to calculate the cycle time in parts per minute is: Cycle Time = Number of Parts / Minutes.

STEPS:

• Select E5.
• Enter this formula.

C5 indicates the parts and D5 the duration in minutes.

• Press Enter button to see the result in E5.

• Drag down the Fill Handle.

The result is displayed in column E.

Example 3 – Computing Minutes per Part Cycle Time in Excel

To calculate the minutes per part cycle time, use this formula: Cycle Time = Minutes /Number of Parts.

STEPS:

• Select a cell to calculate the cycle time.
• Enter the formula.

C5 is the parts and D5 the duration of the parts in minutes.

• Press Enter.
• Click the cell we to see the formula in the formula bar.

• Drag down the Fill Handle .

Column E showcases the cycle time.

Example 4 – Cycle Time Calculation in Parts per Seconds

To find the parts per second use the formula: Cycle Time = Number of parts / Minutes*60.

STEPS:

• Select E5.
• Enter the formula.

C5 represents the parts and D5 the duration of the parts in minutes.

• Press Enter.
• The result is shown in the cell and the formula is displayed in the formula bar.

• Drag down the Fill Handle.

The cycle time is calculated in column E.

Example 5 – Calculating Seconds per Part Cycle Time

The formula to calculate seconds per part cycle time is Cycle Time = Minutes*60 / Number of parts.

STEPS:

• Select E5.
• Enter the formula.

C5 defines the parts and D5 the duration in minutes.

• Press Enter.
• The result is displayed and the formula can be seen in the formula bar.

• Drag down the Fill handle.

The result is displayed in column E.

Example 6 – Cycle Time Calculation in Parts per Hour

To calculate parts per hour, use this formula  Cycle Time = (Minutes / 60) / Number of parts.

STEPS:

• Select E5.
• Enter this formula.

C5 is the parts and D5 the duration of parts in minutes.

• Press Enter.

The result is displayed and the formula can be seen in the formula bar.

• Drag down the Fill Handle.

The parts per hour are displayed in column E.

Example 7 – Calculate the Cycle Time in Hours per Part in Excel

Cycle Time = Number of Parts / (Minutes / 60) is the formula.

STEPS:

• Select E5.
• Enter this formula.

C5 indicates the parts and D5 the duration of the parts in minutes.

• Press Enter.

The result is displayed and the formula can be seen in the formula bar.

• Drag down the Fill Handle.

The result is displayed in column E.

Download Practice Workbook

You can download the workbook and practice.

Related Articles

• How to Calculate Turnaround Time in Excel Excluding Weekends
• How to Calculate Years of Service in Excel
• How to Calculate Turnaround Time in Excel
• How to Calculate Average Handling Time in Excel
• How to Calculate Average Response Time in Excel
• How to Calculate Average Turnaround Time in Excel

<< Go Back to Calculate Time | Date-Time in Excel | Learn Excel