Converting a total number of minutes to hours and Minutes

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

Answer
Answer
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.
*** PLEASE READ ***

If this response answers your question, please mark it as the "Answer".

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.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

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

107 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.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 16, 2021 Views 51,103 Applies to: