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

Well, of course not.

The difference between 10:25pm and 10:55pm is exactly 30 minutes, or
1800 seconds. But you have 2026 samples, which, at a second each, comes
to 33 minutes and 46 seconds, which is equivilent to a stop time of
10:58:46pm. The extra second is (I think) due to the first sample being
zero seconds after the start time, instead of 1, so you're actually
only adding 2025 seconds, not 2026.

Your samples are spaced more frequently than one second apart, which is
why using a fixed spacing of a second to start the series doesn't work.
Brian's previous answer about using a formula sounds like the answer,
although I haven't looked at it myself. But he knows what he is talking
about, and the approach is the correct one. It calculates the actual
sample frequency and uses that to calculate the timestamps for each
sample. Try that and see if it doesn't give you the answer you are
looking for.


Paul



On Thu, 11 Sep 2014 06:33:54 -0700 (PDT)
office76#xt <l0c357bn@verizon.net> wrote:

> Thanks again for the replies, this is what I've tried so far: 
>
> The start time was 10:25pm and the stop time was 10:55pm, with 2026
> samples. I first highlight column 'A', and format the cells as
> 'Time', using the 01:37:46pm format. The first cell, A1, gets the
> start time, 10:25:00pm. The second cell gets 10:25:01pm, which is the
> start time with an increment of 1 second. I then highlight these
> first two cells, then drag their lower right corner down the column
> to row 2026. The last cell now reads 10:58:45pm, which does not match
> the stop time of 10:55pm.  
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568p4121956.html
> Sent from the Users mailing list archive at Nabble.com.


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