On 25-02-11 16:16, T. R. Valentine wrote:
> I used FIND to locate the space between the date and the time. I used LEFT
> to extract the characters prior to the space and when that did not produce
> a numerical value, I tried both VALUE and TIMEVALUE to convert it to a
> numerical value. Neither worked.
This seems to be correct, however
1) A2 '=NOW()'
2) B2 '=FIND(" ";A2;1)'
This gives problems, because the second parameter in FIND needs to be text.
The correct way to find the " " would be:
'=FIND(" ";TEXT(A2;"DD-MM-JJJJ UU:MM:SS";1);1)'
The "DD-MM-JJJJ UU:MM:SS" is because my locale setting is Dutch
Hmmmmmz, what happens if i save this, change locate, and re-open this
doc.....
Yes, Mr Valentine, you are right, there is a lot of work to be
done....... :'(
I Think this should be filed as a bug, wonder how OO does do this.
--
Luuk
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
