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 HRS 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


Add Houror 12/24 to add 12 hours:


Add More Hours

Add Hour to Now

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


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