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

Hi :)
If you are not happy with Calc and looking for a reason to use something
else then maybe try Gnumeric.

It is a specialist tool that focusses more on spreadsheeting functionality
without having to worry about any other apps as it's a stand-alone tool.
It co-operates well with LibreOffice/OpenOffice and others in the same

Brian's answer probably works in that too or (unlikely but theoretically
possible) might need a little tweak for Gnumeric.

I still think Mr Drago's post was to help explain Brian's answer rather
than being intended as an answer in it's own right.  It alerts us to the
potential for a "fence post" error and that clarifies why Brian set his
figures as he did.

Now that the question has been extended to a greater sample it might be
better to upload the problem file (or just the sheet) to Nabble or
somewhere so that people can help identify the problem created by
up-scaling the formula.
Regards from
Tom :)

On 10 September 2014 06:09, Brian Barker <> wrote:

At 16:58 10/09/2014 +1200, Steve Edmonds wrote:

I think the trick is to not calculate the difference/no. samples and keep
adding but to calculate the difference and multiply by position over number
of samples added to start time.

For the avoidance of doubt, you will see that this is what my original
suggestion (two days ago) does.

 For a quick test this seems to give times to 0.00 of a second ...

No, it gives times to about *ten* fractional places of a second
(0.0000000000), but it may well *display* with less precision - depending
on your cell formatting. This is one of the original questioner's

 Got to dash to beat the traffic, but can post the formula when I'm home.

Or see my original reply: " In B2, enter: =B1+(B$6-B$1)/5 and fill this
down to B5"!

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.