Am 08.08.2012 18:12, 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.
Thanks for the responses.
I'm being given an already filled-out .xlsx, but I'm not seeing a difference
if I save it to .ods.
The cells are identified as in H:MM format, but the actual measurements are
in minutes and seconds (with a few H:MM:SS sprinkled in). It's a bit
confusing because what I
2012/8/8 teknow teknowledg...@gmail.com:
Thanks for the responses.
I'm being given an already filled-out .xlsx, but I'm not seeing a difference
if I save it to .ods.
The cells are identified as in H:MM format, but the actual measurements are
in minutes and seconds (with a few H:MM:SS