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.
In Excel, time is stored as a fractional value where each 1/24th represents one hour of the day.
To add an hour add 1/24 to a time
or 12/24 to add 12 hours:
Add Hour to Now
To add an hour to the current time, add 1/24 to the NOW Function:
Add Hours Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.