Return to Excel Formulas List

Add Seconds to Time – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to add seconds to a time in Excel and Google Sheets.
Add Seconds to Time Main

Add Seconds

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



To add a second add 1/86400 to a time


Add one Seconds

or 59/86400 to add 59 seconds:


Add More Seconds

Add Second to Now

To add a second to the current time, add 1/86400 to the NOW Function:


Add one Seconds to Now

Add Seconds Google Sheets

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

Add-Seconds to 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