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

It might be helpful if you post the actual start/stop times 
for the 2026 samples. There's more than one way to skin this 
cat and I'd only look for solutions outside of Calc as a 
very last resort.

-Bill

On 9/9/2014 8:22 PM, office76#xt wrote:
> Thanks for the replies.
>
>                                            My earlier example was a
> simplified version of the data I'm working with. When Brian & Wdragos
> technique is applied to the 2026 samples I really have, it sort of works so
> I can see what your talking about. I keep altering the incrementation that
> takes place in this technique to try to get the last cell to say the stop
> time.  It comes pretty close but is always off by a few minutes. The reason
> for this is theres a limit to the precision you can do with Times in
> OpenOffice Calc. Using the hr/mn/sec format you can't generate small enough
> increments to get the generated times to match the stop time. If there was a
> hr/mn/sec/fraction of a second format you could do it. In Calc theres  a
> time format that looks like this, but in practice it doesn't 'roll over'
> like say minutes or seconds.
>
> It looks like Calc's stock functions won't do the job. I'm thinking of
> getting around this by finding some source for a stopwatch program, and
> maybe modifiying it to do something similar, but with a greater precision of
> incrementation.
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568p4121744.html
> Sent from the Users mailing list archive at Nabble.com.


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