time to integer2
"Sandy" wrote in
oups.com:
In reading this post and your previous one, why wont the formula that
Tom Ogilvy wrote accomplish what you're trying to do?
Quoted from Tom Ogilvy Fri, Oct 6 2006 12:49 pm from "time to
integer" post
"=SUBSTITUTE(TEXT(AB3,"hhmmss.000"),".","")*1
You may have to adjust the "." for your regional settings.
--
Regards,
Tom Ogilvy "
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
|