2012/8/8 Dan <[email protected]>: > 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: [email protected] 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
