At 08:54 08/09/2014 -0700, Nobody Noname wrote:
Imagine you've collected samples from a data acquisition device, and
know the time you started taking samples (12:04 pm), and when you
stopped (12:36 pm). You'd end up with two columns of data like this:
12.7 12:04 pm
8.9
3.5
2.1
7.2
6.1 12:36 pm
My question is, is there a way to generate the intermediate time
values in the second column?
No - simply because the samples may well have been taken at irregular
intervals!
If you mean that we are to suppose that the intervals were regular,
let's suppose that these values are in cells A1:B6. In B2, enter:
=B1+(B$6-B$1)/5
and fill this down to B5. Note that your times may need to be proper
times (numbers formatted as times) and not text values for this to
work. If the number of samples is itself to be variable, you could
develop a more complicated formula that would count the items and not
have the "5" hard-coded in it.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
