Wow that was easy. Thank you so much.

"Teethless mama" wrote:

=A1/24/60
Format cell as h:mm

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07