Return to Excel Formulas List

Calculate Average Time – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to calculate the average time in Excel & Google Sheets.

Average Time Main

To calculate the average time in Excel, simply use the Average Function on a range of times:

Average Time

Average Time With Condition

You can also use the AVERAGEIF Function to average a range of times that meet certain criteria.  In this case let’s average only times in the morning (before 12:00pm):

AverageIF Time

Averaging Time in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Average Time Google