Return to Excel Formulas List

Add Hours to Time – Excel & Google Sheets

Download Example Workbook

Download the example workbook

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

Add Hours to Time Main

Add Hour

In Excel, time is stored as a fractional value where each 1/24th represents one hour of the day.

Time Portion

To add an hour add 1/24 to a time

=B3+(1/24)

Add Houror 12/24 to add 12 hours:

=B3+(12/24)

Add More Hours

Add Hour to Now

To add an hour to the current time, add 1/24 to the NOW Function:

=NOW()+(1/24)

Add Hour Now

Add Hours Google Sheets

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

Add HRS Time Google

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