2014 Archives by date, by thread · List index

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

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