Convert Minutes to Hours in Excel & Google Sheets

This tutorial will demonstrate how to convert minutes to hours or hours to minutes in Excel & Google Sheets.

HRS MIN Main

Convert Hours to Minutes

To convert hours to minutes all you need to do is multiply the hours by 60:

HRS MINTS

Or you could use the CONVERT Function:

=CONVERT(B3,"hr","mn")

Convert Hour Minute

Convert Minutes to Hours

To convert minutes to hours all you need to do is divide the minutes by 60:

Minute Hour

Or you could use the CONVERT Function:

=CONVERT(B4,"mn","hr")

Convert Minute Hour

Convert Time to Minutes or Hours

Convert Time to Hours

Excel stores time as a decimal value where each 1/24th represents one hour of a day. Understanding this, you can convert a time to hours by multiplying the time by 24:

Time Hour

Convert Time to Minutes

You can convert time to minutes by multiplying the result by an additional 60 (Time * 24 * 60 = number of minutes):

Time Minutes

Format as Number

When you convert time to hours or minutes, Excel may automatically format the result as time (ex. h:mm):

Format

To display the result as a regular number, change the formatting to General:

excel time format to general

Convert Minutes to Hours in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

HRS MIN Google

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!