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

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
eco-system.

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 <b.m.barker@btinternet.com> 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
> misunderstandings.
>
>  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: 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

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