Converting total minutes into hours and minutes in Excel
You're welcome!
Biff
"Colette" wrote in message
...
Thank you so much. It works.
"T. Valko" wrote:
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
|