In this tutorial, you will learn how to calculate average time in Excel.
We can use the AVERAGE function to determine the average time. We should set the Time format to display data in the time values before applying the formula in the cell.
Once you are ready, we can start by using real-life scenarios to help you understand how to calculate average time in Excel.
Table of Contents
Anatomy of AVERAGE Function
AVERAGE(number1, [number2], …)
The average (arithmetic mean) of the arguments is returned by the AVERAGE function.
Calculate Average Time in Excel
Before we begin we will need a group of data to be used to calculate average time in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to calculate the average time between the 3 time. We will insert the following formula =AVERAGE(B2:B4).
Step 3
Once we are done, you will be able to calculate average time.
