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

Hi :)
I thought it was really kind to de-geekify Brain's answer.  The tpyo was
unfortunate but these things happen [shrugs].  The main thing, for me, was
that i could then go back to Brian's answer and understand it more easily.
Thanks and regards from
Tom :)




On 9 September 2014 12:22, William Drago <wdrago@suffolk.lib.ny.us> wrote:

> On 9/9/2014 6:18 AM, Brian Barker wrote:
>
> > At 05:45 09/09/2014 -0400, William Drago wrote:
> >
> > > This is what Brian is trying to explain...
> >
> > I was doing more than try! And no: what you suggest here is not what I
> > was saying.
> >
> >  You've got 6 samples. The first one taken at 12:04PM, the last one at
> > > 12:36PM. The total elapsed time is 12:36PM - 12:04PM = 22 minutes.
> >
> > Er that's *thirty*-two minutes , not twenty-two, by my arithmetic.
>
> 32 minutes, yes! That's what happens when I do math so early in the
> morning.
>
>
> >  Follow these instructions carefully:
> > >
> >
> > Why not follow my instructions instead (which are quite different), where
> > a formula does all the calculation for you, not just the last bit?
>
> Since the OP was confused by your instructions (indicating his level of
> inexperience with spreadsheets) and you did not explain how to fill the
> column or the purpose of $, I offered what I thought would be easier for
> someone at his level to understand. It is not necessarily the best
> approach, but something I thought would solve his problem and he would
> understand. It also demonstrates the ability of a spreadsheet to generate
> data based on a pattern in selected cells. This can be a time saver and is
> not something everyone is aware of.
>
> My solution is not intended as a criticism of your solution, which made
> perfect sense to me and is frequently what I do in my own spreadsheets. I
> merely offered an alternative to someone who was struggling.
>
> Regards,
> -Bill
>
>
>
> --
> 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

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