On 25 February 2011 02:54, Luuk <[email protected]> wrote: > On 25-02-11 05:41, T. R. Valentine wrote: >> Excel could NOT >> do it. > Or, you do not know how to do it? > (i've never worked with Excel2007, but did 'some' things in Excel2003)
I would never claim a possible lack of knowledge! But, in this case, I am fairly certain it wasn't me. 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. Knowing where the space between the date and the time was and determing the LEN of the entire text string, I used MID to extract the characters following the space. When that did not produce a numerical value, I tried both VALUE and TIMEVALUE to convert it to a numerical value. Neither worked. On 25 February 2011 05:37, plino <[email protected]> wrote: > > VALUE and TIMEVALUE apply to TEXT strings ONLY both in Excel and LibO > > If you want to parse a value field you have to use different functions See above., > How did you import the Tab delimited file to LibO? I did not. I had already done a lot of work with the information in Excel which I did not want to redo. I saved my work (in .xls instead of .xlsx) and opened that in Calc. Does Calc have issues with opening tab-delimited files? -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- 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 ***
