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.
92 people found this reply helpful
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.
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:
107 people found this reply helpful