**Turnaround Time** is a very common concept in various aspects such as Education, Work, etc. of our life. You can learn how to **Compute Turnaround Time(TAT)** in Excel from our previous article. And in this article, we will let you know how you can **calculate the Average Turnaround Time** in Excel.

**Table of Contents**hide

**Download Workbook**

You can download the free practice Excel workbook from here.

**What is Turnaround Time (TAT)?**

Before diving into the calculation part, letâ€™s see a glimpse of what the meaning of Turnaround Time is.

**Turnaround Time (TAT)** is nothing but the difference between the **End Time** and the **Start Time** of a project/task.

The amount of time taken to finish a project/ task or fulfil any request is called the **Turnaround Time**. For instance, suppose your math teacher has given you a math problem to solve and he forbid you to start solving the math until he says, â€śStart Writingâ€ť. So, the time when your teacher says â€śStart Writingâ€ť to the time that you finish solving the math, is the **Turnaround Time**.

The **generic formula** to calculate **Turnaround Time** is:

**Turnaround Time = End Time â€“ Start Time**

In the following sections, we will learn how to **calculate the Average Turnaround Time** in Excel.

**What is Average Turnaround Time?**

Just by the name, you can tell that the **Average Turnaround Time** means the **average** of all the **turnaround times** produced.

**Generic formula** to calculate the **Average Turnaround **Time is:

**Average Turnaround Time = (1st Turnaround Time + 2nd Turnaround Time + 3rd Turnaround Time + â€¦â€¦â€¦. + N Turnaround Time)/ Total Count**

Suppose, you have given 5 mathematical problems to solve. You have done the 1st math problem in 6 minutes, 2nd one in 7 minutes, 3rd one in 8 minutes, 4th one in 9 minutes and the last one in 10 minutes. So, the **Average Turnaround Time** here will be,

`Average TAT = (6+7+8+9+10)/5 = 8`

In Excel, to calculate the **Average Turnaround Time**, we use the **AVERAGE function**.

**4 Methods to Calculate Average Turnaround Time in Excel**

In the following section, we will discuss how to **calculate the Average Turnaround Time** in Excel with examples.

**1. Compute Average Turnaround Time in Excel**

Look at the following picture. We have the **Start Time** and the **End Time** of some Projects. With those values, we extracted the **Turnaround Time** for our dataset.

As already mentioned before, if you want to learn details about how to calculate **Turnaround Time** in Excel then follow the article link provided in the introduction of this article. This article is all about how to find the **Average of those Turnaround Times**.

But still, for your better understanding, we have provided the Formula in **Column F** based on which the **Turnaround Time **was calculated. As discussed above, this calculation is nothing but a simple mathematical **subtraction** between the **End Time** and the **Start Time**.

We will see how to get the **Average Turnaround Time **for our dataset in Excel.

**Steps:**

- First, pick any cell to store the
**Average Turnaround Time**(in our case, it is**Cell E11**) - Then, execute Excelâ€™s
**AVERAGE**In our case, the formula for the**AVERAGE**function will be,

`=AVERAGE(E5:E9)`

Here,

**E5:E9**=**Range**of the**Turnaround Time**to calculate their**Average**

- Lastly, press
**Enter**.

The **Average Turnaround Time** for the dataset will be calculated.

**Read More: How to Calculate Time in Excel (16 Possible Ways)**

**2. Estimate Average TAT for DATE Format**

In the previous section, you have learnt how to get the **Average Turnaround Time** when you have hours, minutes, seconds as the input value. But in this phase, you will learn how to extract the **Average Turnaround Time** **in Days** when you have **Date** values.

To find the **Turnaround Time** in days, you have to execute the **NETWORKDAYS function** and pass the **Start Time** and the **End Time** of the Projects. Remember, **NETWORKDAYS** functions calculate while **excluding the weekends **(Saturdays and Sundays).

You can see in the picture shown below that we have provided the formulas that were applied to get the **Turnaround Days** for our dataset in **Column F**. Now, we will see how to get the **Average** **Turnaround** value of those data.

Steps to get the **Average Turnaround Time in days** for our dataset in Excel are shown below.

**Steps:**

- First, pick any cell to store the
**Average Turnaround Time**(in our case, it is**Cell E11**) - Then, execute Excelâ€™s
**AVERAGE**In our case, the formula for the**AVERAGE**function will be,

`=AVERAGE(E5:E9)`

Here,

**E5:E9**=**Range**of the**Turnaround Time**to calculate their**Average**

- Lastly, press
**Enter**.

The **Average Turnaround Time in days **will be calculated for the dataset.

**Read More: Calculate Elapsed Time Between Two Dates in Excel (5 Methods)**

**Similar Readings:**

**How to Subtract Hours from Time in Excel (2 Easy Ways)****Calculate Production per Hour in Excel (4 Ways)****How to Calculate Time Difference Between AM and PM in Excel****Calculate Cycle Time in Excel (7 Examples)****How to Calculate Average Response Time in Excel (4 Methods)**

**3. Compute Average Turnaround Time with One Condition in Excel**

You have already learnt how to calculate the **Average Turnaround Time** for your dataset in Excel. Now we will complicate the scenario a little bit. This time we will learn how to compute the **Average Turnaround Time while excluding one specific value** from our dataset.

We will exclude â€ś**8:28:35 AM**â€ť as an example for this article. We will calculate the **Average Turnaround Time** for our dataset where the time **â€ś8:28:35 AMâ€ť wonâ€™t be included**.

**Steps:**

- First, pick any cell to store the
**Average Turnaround Time**except(in our case, it is*â€ś8:28:35 AMâ€ť***Cell E12**) - Then, execute Excelâ€™s
**AVERAGEIF function**, where pass the range to calculate as the first argument and the condition as the second argument. In our case, the formula for the**AVERAGEIF**function is,

`=AVERAGEIF(E5:E9,"<>8:28:35 AM")`

Here,

**E5:E9**=**Range**of the**Turnaround****Time**to calculate their**Average****â€ś<>8:28:35 AMâ€ť**= Value to exclude

- Lastly, press
**Enter**.

You will get the **Average Turnaround Time** for your dataset **excluding the specific time** condition that you provided.

**Read More: How to Calculate Average Handling Time in Excel (2 Easy Ways)**

**4. Calculate Average Turnaround Time with Multiple Conditions**

In the previous section, you have learnt how to calculate the **Average Turnaround Time** when there is one condition. But what if there are two conditions to fulfil while calculating.

Notice in the following example, we will calculate the **Average Turnaround Time** between the times that are **greater than or equal to the Start Time â€ś9:02:00 AMâ€ť** and **less than or equal to the End Time â€ś6:00:07 PMâ€ť** in our dataset.

We have stored ** â€ś9:02:00 AMâ€ť** in

**Cell D14**and

**in**

*â€ś6:00:07 PMâ€ť***Cell D15**in our Excel spreadsheet.

Steps to find the **Average Turnaround Times while excluding multiple times **are given below.

**Steps:**

- First, pick any cell to store the
**Average Turnaround Time with the excluded times**(in our case, it is**Cell E17**) - Then, execute Excelâ€™s
**AVERAGEIFS function**, where pass the range to calculate as the first argument following the conditions. In our case, the formula for the**AVERAGEIFS**function is,

`=AVERAGEIFS(E5:E9,C5:C9,">="&D14,D5:D9,"<="&D15)`

Here,

**E5:E9**=**Range**of the**Turnaround Time**to calculate their**Average****C5:C9**=**Range**of the**Start Times****D14**= The specific**Start Time to exclude****D5:D9**=**Range**of the**End Times****D14**= The specific**End Time to exclude**

- Lastly, press
**Enter**.

See in **Cell E17**, we have successfully calculated the **Average Turnaround Time with multiple conditions**.

**Read More: How to Calculate the Duration of Time in Excel (7 Methods)**

**Conclusion**

This article explained in detail how to **calculate Average Turnaround Time** in Excel. I hope this article has been very beneficial to you. Feel free to ask if you have any questions regarding the topic.