Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Merge tables with VLOOKUP in Excel
  • How to reference named range different sheet in Excel

Data Analysis Examples

  • How to create Gauge Chart in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Add Outline to Data in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create Thermometer Chart in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation only dates between

Convert decimal minutes to Excel time

by

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

To convert minutes in decimal format to a proper Excel time, divide by 1440.

Formula

=minutes/1440

Explanation

In the example shown, the formula in C6 is:

=B6/1440

Because B6 contains 60 (representing 360 minutes) the result is 60/1440 = 0.04167, since 60 minutes = 1 hour = 1/24 day. Cell D6 shows the same result formatted as time, which displays 1:00.

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 Value Time
1 1/24 60 0.04167 1:00
3 3/24 180 0.125 3:00
6 6/24 360 0.25 6:00
4 4/24 240 0.167 4:00
8 8/24 480 0.333 8:00
12 12/24 720 0.5 12:00
18 18/24 1080 0.75 18:00
21 21/24 1260 0.875 21:00

This means if you have a decimal number for minutes, you can divide by 1440 (24 x 60) to get the correct representation of minutes in Excel. After dividing by 1440, 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 720 (representing 720 minutes) the result is 720/1440 = 0.5. Once a time format like h:mm has been applied, Excel will display 12:00.

Durations

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

[h]:mm // hours > 24
[m]  // minutes > 60

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

Post navigation

Previous Post:

Convert decimal seconds to Excel time

Next Post:

Convert decimal hours to Excel time

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
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • How to extract word containing specific text in Excel
  • How to get last line in cell in Excel
  • Split numbers from units of measure in Excel
  • Split text and numbers in Excel
  • Pad week numbers with zeros in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate number of hours between two times in Excel
  • How to calculate Day of the Year in Excel
  • How to join date and text together in Excel
  • Calculate interest rate for loan in Excel
  • How to calculate principal for given period in Excel
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles