How to Get Average Time in Excel (3 Examples)

Get FREE Advanced Excel Exercises with Solutions!

Excel is a useful program that allows us to perform a variety of numerical calculations such as multiplication, division, addition, subtraction, average, count, and so on. However, when it concerns activities based on time and date, it might be a little perplexing. This article will show you how to determine the average time in Excel for any timing you provide.


Average Time in Excel: 3 Suitable 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. To do so, we’ll use the AVERAGE function and the AVERAGEIF function. The following is an example data set.

Use Formula

1. Use the AVERAGE Function to Get Average Time in Excel

The first general method to get the average time is to use the AVERAGE function. Follow the steps below to do so.

Step 1:

  • Select the cells (C5:C10).

Use Formula to Get Average Time in Excel

Step 2:

  • Choose the Time format from the Number

Use Formula to Get Average Time in Excel

Step 3:

  • In cell E5, type the formula.
=AVERAGE(C5:C10)

Use Formula to Get Average Time in Excel

  • Therefore, you will get the average time.

Use Formula to Get Average Time in Excel


2. Apply Condition to Calculate Average Time in Excel

Excel may also be used to conduct conditional operations. We’ll apply a set of criteria and calculate the average time. Follow the steps below to do a conditional average time calculation.

Step 1:

  • Firstly, select the cells.

Apply Condition to Calculate Average Time in Excel

Step 2:

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

Apply Condition to Calculate Average Time in Excel

Step 3:

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

Apply Condition to Calculate Average Time in Excel

As a consequence, as seen in the figure below, the average time will be displayed.

Apply Condition to Calculate Average Time in Excel


3. Calculate Average Time from Timestamp of Day

For example, say you’ve logged the entry timestamps of every time a certain user entered a website in Excel, and now you want to average the timestamps to forecast the most likely time this person would access the website in the future. So, to calculate the average timestamp, follow the instructions below.

Use Formula

Step 1:

  • Simply type the following formula.
=AVERAGE(C5:C10)

Use Formula

As a result, 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.

Use Formula


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

To sum up, I hope this post has given you a thorough understanding of how to calculate average time in Excel. You should learn all of these processes and apply them to your dataset. Examine the practice booklet and put your newfound abilities to the test. Because of your invaluable support, we’re inspired to continue creating lessons like this.

Please do not hesitate to contact us if you have any queries. Please feel free to offer your thoughts in the comments area below. Stay with us & keep learning.


Calculate Average Time in Excel: Knowledge Hub


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bhubon Costa
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo