Add Up Time (Total Time) in Excel & Google Sheets

This tutorial will demonstrate how to add up time in Excel and Google Sheets.

Add up Time Main

Add Total Time

You may have noticed that when you try to add up times in Excel that the time resets after 24 total hours:

Add Hours Time

If you convert the number format from hh:mm to General you’ll see that the time values add up properly:

Add Up Time

The issue is number formatting; change t

he time format from hh:mm to [h]:mm instead.

To change the number formatting, open the Format Cells Menu with the shortcut CTRL + 1 and change the time format:

time format excel

TEXT Function

You can also use the TEXT Function to display the total time as text:

Add Up Text

Google Sheets Total Time

You can calculate the month name of a date the same in Google Sheets as in Excel:

Add up Time Google