Convert Minutes to Hours in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
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:


Or you could use the CONVERT Function:


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 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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List