Excel: How to Convert Minutes to Hours and Minutes

by Tutor Aspire January 17, 2023

Often you may want to convert minutes to hours and minutes in Excel.

Fortunately this is easy to do and the following step-by-step example shows how to do so.

Step 1: Enter the Data

First, let’s enter the following dataset in Excel that shows the time (in minutes) that it took for various athletes to finish some task:

To display the minutes as hours and minutes, we must first divide each value in the minutes column by 1,440.

We’ll type the following formula into cell C2, then drag and fill the formula down to each remaining cell in column C:

=B2/1440

Next, we need to format the cells so the values are shown in terms of hours and minutes.

To do so, highlight the cells in the range C2:C11, then click the Number Format dropdown menu, then click More Number Formats:

In the new window that appears, click Custom in the Category list, then type [h]:mm in the Type window, then click OK:

Once you click OK, the cells will automatically be formatted as hours and minutes:

For example:

And so on.

The following tutorials explain how to perform other common operations in Excel: