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.

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