Calculate Average Time – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

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

average time

 

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

=AVERAGE(B3:B6)

calculate average time funktion

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(B3:B6,"<12:00 PM",B3:B6)

calculate average time averageif funktion

Averaging Time in Google Sheets

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

Average Time Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List