Learn how to convert time to Seconds using Excel.


Time can be converted into seconds using Excel.

The number 86400 can be used to convert time to seconds.

Conversion number 86400


86400 Explained

Excel uses a 24-hour system.

Each day has 24 hours.

One hour is 60 minutes.

One minute is 60 seconds.

24(hours) * 60(minutes) * 60 (seconds) = 86400


Example

00:01 * 86400 = 60

The example returns 60 because one minute (00:01) is 60 seconds.


 

 


Explanation

Each day has 24 hours.

Each hour can be understood as a percentage of the total hours of the day.

  • 01:00 = 1/24
  • 02:00 = 2/24
  • 03:00 = 3/24
  • and so on.

The percentage can be used to find the seconds.

Example (15:00)

15:00 * 86400 = 54000

Fifteen hours equals 54000 seconds.

15:00 is 15/24 (0.625).

0.625 * 86400 = 54000

Multiply to get 86400

24 (hours) * 60 (minutes) * 60 (seconds) = 86400

 


Login
ADS CODE