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

On 2014-09-10 17: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 misunderstandings.
Just meaning there is a pre-defined format that showed in my test to 
0.00 seconds.
> > 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"!
Hi Brian.
What I am meaning would be
B2=B1+(B$6-B$1)*1//5
B3=B1+(B$6-B$1)*2/5
.
.
B5=B1+(B$6-B$1)*4/5

Using =$B$1+($B$6-$B$1)*(ROW(A3)-ROW($A$1))/(ROW($A$6)-ROW($A$1)) makes 
the formula a bit more transferable.
As you say you can use time format HH:MM:SS.00 or HH:MM:SS.000 as desired.

Steve

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