time to integer2
Bllich wrote in news:Xns98552570FA1DBllichID@
195.29.150.88:
Yes, this solution works written like this
=SUBSTITUTE(TEXT(AB3;"hhmmss,000");",";"")
but for this 00:00:08,908 I get 000008908
and it's not a number, though I don't need
to calculate anything with this expression
but that's the main score that I print to PDF!
I think I will use this anyway, who cares 'bout
the zeroes.. as long as I can sort them right ;)
Ivan
haha, this works!!!
format of the sell I'm writing a number to
has to be general and this
=(SUBSTITUTE(TEXT(AB3;"hhmmss,000");",";""))/1
works perfectly!!
God bless Tom ;)
|