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

Data Analysis

  • How to Create Area Chart in Excel
  • How to calculate current stock or inventory in Excel
  • How to create a Histogram in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Use Data Form to input, edit and delete records in Excel

References

  • How to use Excel ROWS Function
  • How to use Excel TRANSPOSE Function
  • How to use Excel VLOOKUP Function
  • How to get last row in text data in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation date in specific year
  • How To Create Drop-down List in Excel
  • Excel Data validation don’t exceed total
  • Excel Data validation with conditional list

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:

Get day from date in Excel

Next Post:

Calculate loan interest in given year in Excel

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

  • IF, AND, OR and NOT Functions Examples in Excel
  • IF with boolean logic in Excel
  • How to use Excel TRUE Function
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert text timestamp into time in Excel
  • Get project end date in Excel
  • How to calculate Quarter of Date in Excel
  • How to calculate working days left in month in Excel
  • How to get same date next year or previous year in Excel

Grouping

  • Group arbitrary text values in Excel
  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel

General

  • AutoFit Column Width, AutoFit Row Height in Excel
  • Convert column number to letter in Excel
  • How to calculate percent sold in Excel
  • Excel Default Templates
  • How to increase by percentage in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning