Convert Minutes to Hours in Excel & Google Sheets

Download Example Workbook

Download the example workbook

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

mf convert minutes to hours

 

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:

convert time to hours

Convert Time to Minutes

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

convert time to minutes

Format as Number

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

format time as number

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