CALC problem

2020-08-21 Thread Mike Shearer
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 cal

Re: CALC problem

2020-08-21 Thread John van Barneveld
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" To: "OpenOffice Users" Sent: 22/08/2020 1:17:26 PM Subject: CALC problem I have a spreadshe