# How to Calculate On-Time Delivery Performance in Excel: A 3-Step Procedure

Letâ€™s say your dataset contains arrival times, both actual and estimated, for ten stores, and you would like to calculate your delivery performance.

## Step 1: Calculate the Difference Between Estimated Time of Arrival and Actual Time of Arrival

• Calculate the difference between Estimated Time Arrival and Actual Time Arrival.
• Click File.

• Click Options.

• Click Advanced Â â†’ Use 1904 date system â†’ OK.

• Select E5 and enter the following formula.
`=C5-D5`
• Press Enter.

• We now know that Store 1â€™s actual arrival time is an hour later than its estimated arrival time.

To duplicate the formula, click and drag the Fill Handle down the targeted range.

We now know the difference in delivery time for each of the ten stores.

## Step 2: Automate Comments to Account for Time Differences (Such as “On Time” or “Late”)

• Select F5 and enter the following formula:
`=IF(E5<0,"Late","On Time")`
• Press Enter.

We can now see at a glance that Store 1 was late.

To duplicate the formula, click and drag the Fill Handle down the targeted range.

We can now see at a glance which of the stores was late and which was on time.

## Step 3: Calculate On-Time Delivery Percentage

• Select D16 and enter the following formula:
`=COUNTIF(F5:F14,"On Time")/COUNTA(F5:F14)`
• Press Enter.

• To convert to a percentage, click D16, then press Ctrl+1.

• When Format Cells appears, click Number â†’ Percentage (under Category), then select 0 (under Decimal places), then click OK.

We now know that the overall on-time delivery performance is 60%.

## Related ArticlesÂ

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

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF