In this tutorial, you will learn how to convert minutes to hours and minutes in Excel.
Once ready, we’ll get started by utilizing real-world examples to show you how to convert minutes to hours and minutes in Excel.
Table of Contents
Convert Minutes to Hours and Minutes in Excel
Before we begin we will need a group of data to convert minutes to hours and minutes in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want convert minutes to hours and minutes. To do so, we can simply insert the following formula =B2/1440.
Step 3
We will then format the converted minutes to be displayed in h:mm.
Step 4
Once we are done, you will be able to convert minutes to hours and minutes in Excel.
