I would do a rounddown on the value to get the hours, take
the difference between the value and the roundown to het
the fraction of hour and then multiply by 60 to het the
minutes, and then concatenate them together.

if cell a8 has the value try this:

=CONCATENATE(ROUNDDOWN(A8,0),":",ROUND((A8-ROUNDDOWN(A8,0))
*60,0))
-----Original Message-----
Can someone please tell me how to convert a value
formatted as a number and convert it to an hh:mm format
(not in text)? eg. 78.73 hours to 78:44
.