This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
If I have for example 115 minutes then I divide by 60; I get 1.92 which is correct, but I need the .92 to display as the actual number of minutes.
Thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
You may enter the value in cell A1 as 115, in B1 use the formula without quotes "=TEXT(A1/(24*60),"hh:mm")"
Refer the link below for more information:
http://office.microsoft.com/en-us/excel-help/convert-times-HP003056110.aspx
Answer accepted by question author
Try dividing the 115 minutes by 1440 (number of minutes in a day) and then format the cell however you want. For example, h:mm or h.mm or any other way you might want.
=INT(yourm inutes/60)&" : "& TEXT(ROUNDUP(MOD(yourm inutes,60),0),"00")
Where yourminutes = 72, produces "1 : 12"
If I have for example 115 minutes then I divide by 60; I get 1.92 which is correct, but I need the .92 to display as the actual number of minutes.
Thanks
Not real clear what you're wanting.
A1 = 115
=TIME(0,A1,0)
Formatted as h:mm will return 1:55.
Is that what you had in mind?
What kind of range of minutes will you have? If the number of minutes, when converted to h:mm, will be greater than 24 hours then use this format [h]:mm.
--
Biff
Microsoft Excel MVP
If I have for example 115 minutes then I divide by 60; I get 1.92 which is correct, but I need the .92 to display as the actual number of minutes.
Thanks
Subtract 60 and get 55 minutes.
Ron