Calculate Average Time – Excel & Google Sheets

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

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!