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
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:
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 format
2012/8/8 teknow teknowledg...@gmail.com:
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
2012/8/8 Dan elderdanle...@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