Add Hours to Time – Excel & Google Sheets

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

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!