Excel Formula: Convert Time to Decimal Minutes
In this tutorial, it provides a formula for converting time to decimal minutes in Excel.
If you want to follow along with this tutorial, please download the example spreadsheet.
Generic formula:
| Time*1440 |
Arguments
| Time: the excel time that is used to convert to decimal minutes. |
Return Value
The formula returns a value in time format, then format the result as general or number as you need to get the decimal minutes.
How this formula work
Supposing in cell B3, there is a time value, to convert the time to decimal minutes, please use below formula:
| =B3*1440 |
Press Enter key to get a value in time format.
Click Home tab, and go to the Number Format drop-down list to choose General or Number to display the result as a number.
Explanation
There are 24 hours a day, and one hour is equal to 60 minutes. To convert the time to decimal minutes, you should multiply the value 24*60.
Relative Formulas
- Convert Decimal Minutes to Time Format
This tutorial provides a formula to convert decimal minutes to Excel time. - Convert Decimal Seconds To Time
To convert decimal seconds to Excel time in Excel, a formula can help you. - Convert Time to Decimal Hours
Here provides a formula that converts time to decimal hours in Excel and explains how the formula works. - Convert date to text
This tutorial provides the TEXT function to convert a date to text.
Relative Functions
- Excel IF Function
Test for specified conditions, then returns the corresponding values - Excel VALUE Function
Convert text to number. - Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date. - Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date - Excel YEAR Function
The YEAR function returns the year based on the given date in a 4-digit serial number format.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.