Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to add Trendline to a chart in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • How To Insert and Customize Sparklines in Excel
  • How to sum a total in multiple Excel tables

References

  • Two-way lookup with VLOOKUP in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel COLUMN Function
  • How to get last column number in range in Excel
  • Multi-criteria lookup and transpose in Excel

Data Validations

  • Excel Data validation no punctuation
  • Prevent invalid data entering in specific cells
  • Excel Data validation specific characters only
  • How To Create Drop-down List in Excel
  • Excel Data validation don’t exceed total

Convert decimal seconds to Excel time

by

This tutorial shows how to Convert decimal seconds to Excel time  using example below.

To convert seconds in decimal format to a proper Excel time, divide by 86400.

Formula

=seconds/86400

Explanation

In the example shown, the formula in C6 is:

=B6/86400

To display the result as time, apply a time format. Column D shows the same result formatted with [h]:mm.

How this formula works

In the Excel date system, one day is equal to 1, so you can think of time as fractional values of 1, as shown in the table below:

Hours Fraction Minutes Seconds Value Time
1 1/24 60 3600 0.04167 1:00
3 3/24 180 10800 0.125 3:00
6 6/24 360 21600 0.25 6:00
12 12/24 720 43200 0.5 12:00
18 18/24 1080 64800 0.75 18:00
24 24/24 1440 86400 1.0 21:00

Since there are 24 hours in a day, 60 minutes in each hour, and 60 seconds in each minute, you need to divide by 24 * 60 * 60 = 86400 in order to convert decimal seconds to a value that Excel will recognize as time.  After dividing by 86400, you can apply a time format of your choice, or use the result in a math operation with other dates or times.

In the example, since B11 contains 43200 (representing 43200 seconds, or a half day) the result is 43200/86400 = 0.5. Once a time format like h:mm or [h]:mm is applied, Excel will display 12:00.

Displaying a time duration

To display hours that represent a duration longer than 24 hours, minutes in durations longer than 60 minutes, or seconds in durations over 60 seconds, you’ll need to adjust the number format by adding square brackets.

[h]  // for hours greater than 24
[m]  // for minutes greater than 60
[s]  // for seconds greater than 60

The brackets tell to Excel the time is a duration, and not a time of day.

Note: to use square brackets, you’ll need to create and apply a custom number format. Select cells, then go to Format Cells (Control + 1) > Number > Custom.

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use IFS function in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel

Date Time

  • Add decimal hours to time in Excel
  • Add years to date in Excel
  • Convert text to date in Excel
  • Get work hours between dates in Excel
  • How to join date and text together in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • How to randomly assign people to groups in Excel

General

  • How to create dynamic named range with INDEX in Excel
  • Excel Ribbon Quick Overview For Beginners
  • How to fill cell ranges with random number from fixed set of options in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • How to password protect excel sheet?
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning