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.bar...@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+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 > > -- 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