Excel convert time to seconds

This article outlines how to convert time to seconds in Excel.

Converting time in Excel

It may be useful to convert the time in Excel from the standard hours and minutes format to be seconds only.  In order to do this, there are two main methods.  The best method is to sum the formulas HOUR, MINUTE and SECOND to get the total seconds. The following methods finds how many seconds have elapsed from the days midnight (12 AM).

Example of how to convert time to seconds in Excel

(See screenshots below)

If we take the example time as being 1:40:30 AM and want to figure out how many seconds that is, we can use the following approach.

Step 1 Make sure the time is formatted properly – go to Format Cells (press Ctrl + 1) and make sure the number is set to Time.

Step 2 Use the =HOUR(B2) formula to get the number of hours from the time and multiply by 3600 (there are 3600 seconds in every hour)

Step 3 Use the =MINUTE(B2) formula to get the number of minutes from the time and multiply by 60 (60 seconds in every minute)

Step 4 Use the =SECONDS(B2) formula to get the number of seconds from the time

Step 5 Add up the three pieces to get the total seconds

Step 6 Make sure it’s formatted properly as a Decimal, and not as Time (press Ctrl +1 and select Decimal)

Congratulations, you have now used Excel to convert time to seconds!