Richard Detwiler wrote:
<snip>
One alternative I tried is copying the results into a Calc
spreadsheet, and using the add-on Text to Columns feature to separate
them into columns. The problem with this is that Calc insists on
converting the times into a non-meaningful (to me anyway) decimal; for
example 20:00 (which is 20 minutes) is converted in 0.83 (which I
assume is the fraction of a day that 20 hours is). This happens even
if I pre-format the entire sheet to text format. I've figured out how
to convert this decimal back into the right number of minutes, but the
problem then is that it is in minutes and decimal minutes (21.5 for
example) instead of minutes and seconds (21:30). I know I could figure
out a way by going through a number of operations to get 21.5 to read
21:30 again, but at some point, this becomes more work than manually
replacing the spaces with tabs would be.
One possible solution is to use a spreadsheet where the default format
is text. F11, right-click "Default", select the "Numbers" tab and find
and select the text format.
Then, place the Paste icon on your toolbar. It has an arrow with a
dropdown list of paste options. Choose "Unformatted text".
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
