excel - How to change Format "Hours" to "hour : minutes" in excel

Question

hi everyone i have one columns is Duration columns, the column is in hour format, and I want to convert it to "hour:minutes" format, what formula can I use in excel?

i use =TEXT(A1/24,"hh:mm")

标签： excelexcel-formula

Answer 1

You need to divide hours by 24. Try below formula-

=TEXT(A1/24,"hh:mm")

Check this article from exceljet.net Convert decimal hours to Excel time.

From @Gary's Student answer, you can also use same format with text function.

=TEXT(A1/24,"[hh]:mm")