Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert minutes to hours in Excel and Google Sheets
Topic:Unit conversionExcel & Google Sheets
=A2/60✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Minutes |
| 90 |
=A2/60→1.5
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
- 1A2 holds the number of minutes.
- 2Divide by 60 to get hours.
- 390 becomes 1.5 hours.
Tips
- To show hours and minutes as time, format the cell as [h]:mm and divide by 1440 instead.
- Round with ROUND(A2/60,2) to keep two decimals.
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
How do I convert to hours and minutes instead of a decimal?
Divide minutes by 1440 and format the cell as [h]:mm to display elapsed time.
More on Unit conversion
See all →How-to
How 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.
How-toHow to convert bytes to megabytes
Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.