• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Converting minutes to hours and minutes format (HH:MM)

0 Comments

To convert minutes to hours and minutes (HH:MM) in Excel, you can use a simple formula. Multiply the number of minutes by (24*60) which is the total number of minutes in a day. This will return a number with decimals, where the integer part represents hours, and the decimal part represents minutes. You can then apply the [h]:mm format in the custom formatting option to convert this number to the hours and minutes format.

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

Here are the steps to convert minutes into hours and minutes using the formula method in Excel:

  1. Refer to the cell where you have the minutes value in cell A1.
  2. Type the division operator (/) and enter starting parentheses.
  3. Enter 24, type the division operator (/) again, and enter 60.
  4. Close the parentheses and hit enter to get the result in hours with decimal points.
  5. To convert the decimal points to minutes, apply the [h]:mm format in the custom formatting option.
    Converting minutes to hours and minutes format (HH:MM)

    Converting minutes to hours and minutes format (HH:MM)

 

Alternatively, you can use the TEXT function to add time for the value within the formula.

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

This formula works the same as the earlier method, but you can avoid changing the formatting of the cell.

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

The formula is:

=TEXT(A1/(24*60),”[h]:mm”)

minutes format 5

You can also use the formula A1/60 to convert minutes to hours and minutes as a number.

minutes format 6

In this formula, the hours will be an integer and minutes will be a decimal.

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

Lastly, you can use the CONVERT function in Excel to convert minutes to hours.

Converting minutes to hours and minutes format (HH:MM)

Converting minutes to hours and minutes format (HH:MM)

This function requires you to specify the minute value, the original unit of the value (minutes “mn”), and then the conversion unit (hours “hr”).

minutes format 9

The formula is:

=CONVERT(A1,”mn”,”hr”)

Rate this post
22
233 Views
How to Draw a Line in ExcelPrevHow to Draw a Line in ExcelMay 8, 2023
How to Convert Time Value to Minutes in Excel Using FormulaMay 8, 2023How to Convert Time Value to Minutes in Excel Using FormulaNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
Products
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Windows Server2008 R2 Remote Desktop Services user connections (20)cal Windows Server2008 R2 Remote Desktop Services user connections (20)cal $29.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.