Thread
:
Replace Please
View Single Post
#
2
Don Guillett
Posts: n/a
this seems to work if i8 is formatted as text and entered as 09.30
=TEXT(LEFT(I8,LEN(I8)-FIND(".",I8))&":"&RIGHT(I8,FIND(".",I8)-1),"HH:MM")
--
Don Guillett
SalesAid Software
"Steved" wrote in 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.
Reply With Quote