Try one of these:

To convert the values in place:

Enter 1440 in some empty cell
Now, copy that cell, Goto EditCopy
Select the values to convert
Goto EditPaste SpecialDivideOK
Format the cells as [h]:mm

Or:

A1 = 127

=A1/1440

Format as [h]:mm

Biff

"Colette" wrote in message
...
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