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

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

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):

Averaging Time in Google Sheets

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