Add Seconds to Time – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on September 7, 2023
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 Function

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

AI Formula Generator

Try for Free

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