2014 Archives by date, by thread · List index

# 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:
```
```
```
```
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
```

### Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.