Hi all
I have a column of time formatted as General which displays as 10.5 meaning 10 hours and 50 minutes. I would like to convert it to a time format (hh:mm) so I can use it in a calculation. I tried =TEXT(D8/24,"hh:mm") but this returns 10:30 not 10:50 which is the time I am looking for.
Is there anyway to do this?

Regards
Browny