Re: [libreoffice-users] Re: Generate a column of times

At 17:29 08/09/2014 -0700, Nobody Noname wrote:
> The data acquisition device samples at "approximately 1 sample per 
> second" not a nice fixed sample rate.

That's odd, as your example had them over six minutes apart.

> If the sample values are in column A1, ...

Hold on: A1 is a cell, not a column. Columns are lettered A, B, and 
so on. You are using a spreadsheet document, not a table in a text 
document, aren't you? Spreadsheets give you more flexible calculation 
facilities.

> then I'd like an "approximate" time-line in the cells between the 
> start logging and stop logging times ...

That was clear in your earlier message.

> ... in column B2.

B2 is a cell; B is a column. Your time values are in column B - with 
the six values being in cells B1 to B6 (and the data in A1 to A6).

> What I'm after is to look at my notes taken at different times (the 
> time noted) during logging, and identify the approximate sample that 
> corresponds to them.

Good.

> I'm afraid I don't understand your example as it looks like you have 
> the samples in a row not a column.

That's not so, and I don't see how it looks so (providing you are 
using a spreadsheet). I put the values you offered into the top left 
corner of a spreadsheet, so your data was in A1 to A6 and the two 
time values in B1 and B6. I gave you a formula for B2 that would fill 
down to B5 to give the results you need.

Brian Barker  


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted