On Sun, 23 Aug 2009 22:18:58 -0400, "Rick Rothstein"
wrote:

Here is another non ATP formula as well...

=--SUBSTITUTE(TEXT(H1,"0.00"),".",":")

I believe this method requires that one be using the colon as a time separator
in the Regional and Language Windows settings. I don't know of any countries
that don't use it, but someone might have customized it.
--ron