How to Add Hours and Minutes in Excel

Written by david nield Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Add Hours and Minutes in Excel
With the right formatting, Excel can add up hours and minutes for you. (Stockbyte/Stockbyte/Getty Images)

Part of the appeal of Microsoft Excel is that it can turn its hand to a wide variety of tasks, and that includes working with time values as well as standard numbers. The ability to add hours and minutes together depends on the formatting you've applied to the cells you're working with: you must ensure that the cells in question are configured to hold hours and minutes to enable the problem to recognise and add them together correctly.

Skill level:

Things you need

  • Microsoft Excel

Show MoreHide


  1. 1

    Launch the Excel application and open the spreadsheet you wish to work with. Alternatively select the "Blank workbook" option from the Start screen to begin from scratch.

  2. 2

    Enter the hours and minutes values into a column of cells in your spreadsheet, using the hh:mm format.

  3. 3

    Select all of the cells you've entered values into, then open the format drop-down menu from the Number section of the Home tab on the ribbon menu and select "More Number Formats."

  4. 4

    Choose "Custom" from the Category list under the Number tab on the Format Cells dialog box, then select "[h]:mm:ss" from the Type list. In the input box directly below the Type heading, you can delete the "ss" values if you don't wish to display seconds alongside hours and minutes. Click "OK" to confirm.

  5. 5

    Click inside the cell directly below the list of times you want to add together. Type "=SUM(B2:B6)" and press "Enter," replacing "B2" and "B6" with the first and last cells containing times.

  6. 6

    Right-click on the cell containing the total value and choose "Format Cells." The selected format should be the "[h]:mm:ss" (or "[h]:mm") format you configured earlier, but you can apply it again from here if not.

Tips and warnings

  • Other types of calculations can be applied to cells containing hours and minutes -- you can subtract one time from another, for example. You can also use the custom format option to configure different types of formatting, such as "hh:mm" instead of "[h]:mm" if you don't want the number of hours to be able to exceed 24.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.