Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.