[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Can't Sum() time measurements
- Subject: Re: [libreoffice-users] Can't Sum() time measurements
- From: Johnny Rosenberg <firstname.lastname@example.org>
- Date: Wed, 8 Aug 2012 19:21:20 +0200
- To: email@example.com
2012/8/8 Dan <firstname.lastname@example.org>:
> teknow wrote:
>> I have a list of measured times in [H]:MM:SS format and I would like to
>> them. If I put in a formula:
>> = B2+B3+B4+B5
>> it works, but if I try:
>> I get "00:00:00" as a result. What am I missing?
>> I have tried both LibO 220.127.116.11 and 18.104.22.168
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.
> 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:
> Using = SUM(B2:B5), I get 98002:00:59. (Result using 22.214.171.124)
> What you have not mentioned was the times that you used that gave you
> problems. That might give a clue.
For unsubscribe instructions e-mail to: email@example.com
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
|[libreoffice-users] Can't Sum() time measurements||teknow <firstname.lastname@example.org>|
|Re: [libreoffice-users] Can't Sum() time measurements||Dan <email@example.com>|
- Prev by Date: Re: [libreoffice-users] Can't Sum() time measurements
- Next by Date: Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?
- Previous by thread: Re: [libreoffice-users] Can't Sum() time measurements
- Next by thread: Re: [libreoffice-users] Can't Sum() time measurements