How to Convert Hours to Minutes in Excel (Time Conversion Step)
When Excel hours are stored in different formats, the same time value can give you very different-looking results. This tutorial shows how to convert both decimal hours and hh:mm time entries into minutes in Excel. You’ll walk away able to use the right formula for each format and fix the number formatting when Excel displays a time instead of a minute total.
Covered inside:
→ Creating a new column for minutes from decimal hours
→ Converting decimal hours by multiplying by 60
→ Filling the formula down through the remaining rows
→ Creating a second column for hh:mm time values
→ Converting Excel time values by multiplying by 1440
→ Changing the result format from Time or Custom to Number
Do you usually track hours as decimals like 2.5, or as time values like 2:30? Drop a comment with which format you use, especially if Excel has ever displayed your result as a time instead of minutes.
#Excel #ExcelTutorial #ExcelFormulas #TimeConversion #MinutesCalculation #DecimalHours #HHMMTime #SpreadsheetTips #OfficeProductivity #DataCleanup #Excel2026