Excel - converting minutes to hours and minutes in hh:mm format
Is there a way in Excel to convert minutes to hours and minutes in hh:mm format. For example, convert 167 minutes to 2:47.
Here is one way to achieve this.
Divide the minute value by 1440 (A1/1440).
Format the value as "Time".
Goto: https://www.accountingweb.com/technology/excel/display-times-as-hoursminutes-in-excel for more info.