Divide the value by 24 and format as time.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Paul" wrote in message
...
Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into
hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul