Convert timevalue to time

I have a timevalue (like 0.4791) in a cell. I would like to display 11:30 WITH the use of a formula. I do NOT want to change the cell formatting.

Timevalue("11:30") = 0.4791. What is the inverse of this formula?

Why do you need to use a formula per se?

First, TIMEVALUE("11:30") returns 0.479166666666667, which rounds to 0.4792.

If you have the first value in a cell, simply format the cell as Custom hh:mm to see 11:30.

Now, if you really mean that you want a function that you can use in a text expression (e.g., "the time is " & ...), you might use TEXT(A1,"hh:mm").

But note that if you have the value 0.4791, that returns "11:29", not "11:30".

If your intent is round the approximate decimal number to hr:min, use: --TEXT(ROUND(A1*1440,0)/1440,"hh:mm") for numeric time formatted as Custom hh:mm. Omit the double negate ("--") if you want just the text.