How to Convert Minutes to Hours in Excel?

Enter the minutes value in a cell

Divide the minutes by 60 using a formula like `=A1/60`

Format the result cell as Number if you want decimal hours

Format the result cell as Time if you want an hours:minutes display

Use `=INT(A1/60)` to return only whole hours

Use `=MOD(A1,60)` to return remaining minutes

Use `=TEXT(A1/1440,”h:mm”)` to display minutes as hours and minutes

Copy the formula down for multiple rows

Suggested for You

Trending Today