How to Calculate Average Time in Excel (With Examples)


You can use the following formula to calculate an average time value in Excel:

=AVERAGE(A2:A11)

This particular formula calculates the average time value in the range A2:A11 and assumes that each value in the range is in a valid time format.

The following example shows how to use this formula in practice.

Example: Calculate Average Time in Excel

Suppose we have the following list of times in Excel:

To verify that the times are in a valid format, we can highlight the range A2:A11, then click the Number Format dropdown menu from the Number tab within the Home tab on the top ribbon:

Once we click More Number Formats, a new screen will appear that shows which format Excel has chosen for the values:

In this example, Excel has chosen h:mm:ss AM/PM, which is the correct time format.

If your time values are in another format, simply click on the appropriate format from the list of options.

We can then click OK.

Next, we can use the following formula to calculate the average time value:

=AVERAGE(A2:A11)

The following screenshot shows how to use this formula in practice:

calculate average time in Excel

We can see that the average time is 12:11:51 PM.

Example: Calculate Average Time with Condition in Excel

We can also use an AVERAGEIF function to calculate the average time based on a condition in Excel.

For example, we can use the following formula to calculate the average time only for the times that occur after 12 PM:

=AVERAGEIF(A2:A11, ">12:00:00 PM")

The following screenshot shows how to use this formula in practice:

Excel returns a numerical value, but we can click the Number Format dropdown menu again and click Time to convert this numeric value to a time value:

The average time among the times that occur after 12 PM is 5:18:19 PM.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

How to Calculate Average If Cell Contains Number in Excel
How to Use AVERAGEIF with Multiple Ranges in Excel
How to Calculate Average Excluding Outliers in Excel

Leave a Reply

Your email address will not be published.