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

2012-08-09 Thread Brian Barker
At 09:12 08/08/2012 -0700, Nobody Noname 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 don't know why these should be differe

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

2012-08-08 Thread Johnny Rosenberg
2012/8/8 Dan : > 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 Li

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

2012-08-08 Thread Johnny Rosenberg
2012/8/8 teknow : > 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? Exactly how did you enter those time values in the fir

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

2012-08-08 Thread Dan
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. Did you forma

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

2012-08-08 Thread teknow
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. -- View this message in context