Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert hours to minutes in Excel and Google Sheets
Topic:Unit conversionExcel & Google Sheets
=A2*1440✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Hours (as time) | Minutes |
| 2:30 | |
| 1:15 | |
| 0:45 | |
| 8:00 |
=A2*1440→150
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1If A2 contains a time value formatted as time (e.g., 2:30), enter =A2*1440. Format the result as a Number.
- 2If A2 contains a decimal number representing hours (e.g., 2.5 for 2.5 hours), enter =A2*60.
- 31440 is the number of minutes in a day (24 hours x 60 minutes). Since time values are fractions of a day, multiplying by 1440 converts to minutes.
- 4To get whole minutes, wrap with INT: =INT(A2*1440).
- 5To extract just the minute portion: =HOUR(A2)*60+MINUTE(A2).
Tips
- After multiplying a time by 1440, make sure to format the result cell as a Number, not a Time — otherwise Excel will interpret the large number as a date/time and display it incorrectly.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Why does =A2*1440 show a weird date or time instead of minutes?
The result cell is formatted as a Date or Time. Change the cell format to Number or General: right-click the cell, Format Cells, and select Number.
How do I convert minutes back to a time value?
Divide the minutes by 1440: =A2/1440. Then format the result cell as a Time to see it as hh:mm.
More on Unit conversion
See all →How-to
How to convert minutes to hours
Turn a number of minutes into decimal hours by dividing by 60. The same simple formula in Excel and Google Sheets.
How-toHow to convert inches to centimeters
Multiply the inch value by 2.54 or use the CONVERT function to change inches to centimeters in Excel or Google Sheets.
How-toHow to convert kilograms to pounds
Multiply kilograms by 2.20462 or use CONVERT to change kg to pounds in Excel or Google Sheets instantly.
How-toHow to convert Celsius to Fahrenheit
Multiply Celsius by 9/5 and add 32, or use the CONVERT function, to change temperatures in Excel or Google Sheets.
How-toHow to convert miles to kilometers
Multiply miles by 1.60934 or use CONVERT with 'mi' and 'km' units to change miles to kilometers in Excel or Sheets.
How-toHow to convert feet to meters
Multiply feet by 0.3048 or use CONVERT with 'ft' and 'm' to change feet to meters in Excel or Google Sheets.