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 <l0c35...@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+unsubscr...@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
