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