Re: [libreoffice-users] Can't Sum() time measurements

[Johnny Rosenberg <gurus.knugum@gmail.com>]

2012/8/8 Dan <elderdanlewis@gmail.com>:
> teknow wrote:
>>
>> I have a list of measured times in [H]:MM:SS format and I would like to
>> sum
>> them.  If I put in a formula:
>>
>> = B2+B3+B4+B5
>>
>> it works, but if I try:
>>
>> =Sum(B2:B5)
>>
>> I get "00:00:00" as a result.  What am I missing?
>>
>> I have tried both LibO 3.5.5.3 and 3.6.0.4
>>
>> Thanks.

The easiest way to find out is, as far as I know:
1. Create a spreadsheet that displays the problem.
2. Upload the spreadsheet somewhere (like DropBox, UbuntuOne or whatever).
3. Post the link in this thread.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
>      Did you format column B  as Time, add [H]:MM:SS to the Format code box,
> click the green check (tick), and click OK? If you do not format the cells
> into which you enter these times, you are likely to get errors.
>      Here are three Times using this format in cells B2-B5:
>
> 11284:00:00
> 58528:59:59
> 12:01:01
> 28176:59:59
>
>
>      Using = SUM(B2:B5), I get 98002:00:59. (Result using 3.6.0.4)
> What you have not mentioned was the times that you used that gave you
> problems. That might give a clue.
>
> --Dan

-- 
For unsubscribe instructions e-mail to: users+help@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