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

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