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