Try:

=SUBSTITUTE(TEXT(A1,"#.00"),".",":")*1

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello from Steve Dee

I would like to please to the following

replace Decimal with colon to make it into time

as an example 9.30 to 9:30 please

if I use . then replace : using 9.30 as an example it
will
return 9.03 so I need a formula please.

Thanks for your help in this matter.
.