maybe you didn't copy the whole formula. The *1 on the end (as written)
would remove the zeros.

=SUBSTITUTE(TEXT(AB3,"hhmmss.000"),".","")*1

as to the semicolon:

You may have to adjust the "." for your regional settings.

perhaps wasn't complete in stating that you might have to adjust the commas
in the formula as well.

--
Regards,
Tom Ogilvy




"Bllich" wrote in message
...
"Tom Ogilvy" wrote in
:

I formatted the cells AC3 as General. Pasted in my formula and copied
it down the column. It immediately returned these scores:

44908 <=== AC3
28908
12908
32908
28908
10908
50908
8908
28908

yes yes .. I was twisting your formula and got the same also.. ;)

I posted again "time to integer2" article on groups later on
and Sandy instructed me to check it out again and I did!

though I had to divide whole formula by 1 to get rid of the zeros
and i needed to change commas to ;

it works, thanks man

--

Bllich