2014 Archives by date, by thread · List index

# 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.
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
```