How do I convert minutes to hours:minutes?
 

I am building a spreadsheet that tracks the minutes to complete specific
tasks. I have not been able to find a formula(s) that will convert the
minutes into hrs:min notation. Thank you.

XL stores times as fractional days, so if you have your minutes value in
A1, divide by 24*60:

B1: =A1/1440


and format B1 as hh:mm


In article ,
Marc Todd <Marc wrote:

I am building a spreadsheet that tracks the minutes to complete specific
tasks. I have not been able to find a formula(s) that will convert the
minutes into hrs:min notation. Thank you.