Convert Time to Seconds – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on April 21, 2022
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to convert a time value to seconds in Excel & Google Sheets.

convert time to seconds


Convert Time to Seconds – Excel

Excel stores time as a decimal value where each 1/24th represents one hour of a day. Understanding this, you can convert a time to seconds by multiplying the time by 86400:


Why does this work? Remember that there are 24 hours in a day, 60 minutes in an hour, and 60 seconds in a minute. So there are 24*60*60=86,400 seconds in a day. By multiplying the time by 86,400 you calculate the number of seconds corresponding to the time.

Format as Number

When you multiply time by 86,400, Excel may format the result as time (ex. h:mm):

Value Time

To display the result as a regular number, change the formatting to General:

excel time format to general

Convert Time to Seconds in Google Sheets

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

Time Seconds 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