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

Data Analysis

  • How to calculate correlation coefficient Correlation in Excel
  • How to count table rows in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • Number and Text Filters Examples in Excel
  • Data Series in Excel

References

  • How to use Excel FORMULATEXT function
  • Basic INDEX MATCH approximate in Excel
  • Get nth match with INDEX / MATCH in Excel
  • How to use Excel MMULT Function
  • How to reference named range different sheet in Excel

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation don’t exceed total
  • Excel Data validation whole percentage only
  • Excel Data validation exists 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

Logical Functions

  • Not Equal To ‘<>‘ operator in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • SWITCH function example in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • Get work hours between dates in Excel
  • Calculate days remaining in Excel
  • Display Days in month in Excel
  • Calculate expiration date in Excel
  • How to calculate quarter from date in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • Group times into unequal buckets in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign people to groups in Excel

General

  • With vs Without Array Formula in Excel
  • Spell Check in Excel
  • Subtotal by invoice number in Excel
  • How to generate random times at specific intervals in Excel
  • How to count total number of cells in a rectangular range in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning