You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Mike Shearer <Mi...@westnet.com.au> on 2020/08/22 03:17:26 UTC
CALC problem
I have a spreadsheet containing information about events that occur at
various times over two weeks. I wish to sort the entries by the elapsed
time in minutes between successive events. A simplified example: column
A and B contain the date and time when events occur, column C contains
the calculated time delay between events using "=B2-B1" displayed as
hour:minutes. Column D calculates the time elapsed between events in
minutes using "=HOUR(C2)*60+MINUTE(C2). I want to "play" with the
values in column D, such as sorting them and charting the results to
highlight various characteristics of the original data.
How can I copy the calculated values from column D rather than take the
formulae that determine the values?
Mike Shearer
Re: CALC problem
Posted by John van Barneveld <jv...@bigpond.com>.
Use the COPY as normal then instead of PASTE use PASTE SPECIAL and
select what you want to paste eg "numbers".
I hope this helps
John van Barneveld
------ Original Message ------
From: "Mike Shearer" <Mi...@westnet.com.au>
To: "OpenOffice Users" <us...@openoffice.apache.org>
Sent: 22/08/2020 1:17:26 PM
Subject: CALC problem
>I have a spreadsheet containing information about events that occur at various times over two weeks. I wish to sort the entries by the elapsed time in minutes between successive events. A simplified example: column A and B contain the date and time when events occur, column C contains the calculated time delay between events using "=B2-B1" displayed as hour:minutes. Column D calculates the time elapsed between events in minutes using "=HOUR(C2)*60+MINUTE(C2). I want to "play" with the values in column D, such as sorting them and charting the results to highlight various characteristics of the original data.
>
>How can I copy the calculated values from column D rather than take the formulae that determine the values?
>
>Mike Shearer
>
>
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org