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

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:

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

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

[libreoffice-users] Re: Aack! Uninstall removes file types!

I got a private response that indicates I may not have made myself clear, so I am answering here. The problem I see is that uninstalling LO removes file associations MS Office had all along. In other words, though MS Office is still installed and was always the default .doc/.docx, .xls/.xlsx,

[libreoffice-users] Aack! Uninstall removes file types!

Hi, We have a generic system image with both MS Office and (at my insistence) LibreOffice. Previously we had the Go flavor of OpenOffice. I first noticed something was wrong when I uninstalled Go-OO and installed LO. I did not agree to making LO the default handler for MS Office documents