# How to Get Average Time in Excel (3 Examples)

We’ll show you three examples of how to calculate the average time from a data collection of specific times in the sections below. Here is an example data set.

### Method 1 – Use the AVERAGE Function to Get the Average Time in Excel

Steps:

• Select the cells C5:C10.

• Choose the Time format from the Number category.

• In cell E5, insert the following formula:
`=AVERAGE(C5:C10)`

• You will get the average time.

### Method 2 – Apply a Condition to Calculate the Average Time in Excel

Steps:

• Select the cells.

• Press Ctrl + 1 to open the Format Cells dialog box.
• Click on the Custom category.
• Select the time format h:mm:ss AM/PM.
• Press Enter.

• To find the average time excluding 3:48:00 PM, use the following formula.
`=AVERAGEIF(C5:C10,"<>3:48:00 PM",C5:C10)`

• Here’s the result.

### Method 3 – Calculate the Average Time from the Timestamp of a Day

We’ve logged the entry timestamps of every time a certain user entered a website in Excel and want to average the timestamps to forecast the most likely time this person would access the website in the future.

Steps:

• Use the following formula.
`=AVERAGE(C5:C10)`

You can see that the average is presented, but it is not the same as the overall average time. The dates were not in the same interval; therefore, they differ.

## Calculate Average Time in Excel: Knowledge Hub

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

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF