1. Home

How to Convert Time to Seconds using Excel

Learn how to convert time to Seconds using Excel

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 * 84600 = 54000

    Multiply to get 86400

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

    function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }

    Categories

    HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

    Contact US