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

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: 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