https://bugs.documentfoundation.org/show_bug.cgi?id=161043
--- Comment #6 from Colin <[email protected]> --- (In reply to ady from comment #5) > (In reply to Colin from comment #4) > > > Both this and SS,00 make matters worse; > > In my case, I open attachment 194087 [details], cell D1, [CTRL]+[1] > the > format shows: > MM:SS.00 > and I change it to: > [HH]:MM:SS > > Accept the new cell format. If needed, expand the width of the column. Cell > D1 now shows 547:12:52. I have not modified any other cell. > > Tested with LO 7.5.3.2 and recent 24.8 alpha. I'm now well aware that I can compromise reality to satisfy LO but ever since I was about 5, I understood that 27 minutes and 37 minutes was 64 minutes and I could CHOOSE to represent that as 64 minutes or 1 hour and 4 minutes where both are correct. but 4 is an error. Not only does LO insist that 37 and 27 is 4 - SUBTOTAL()ing 7779 smaller amounts to arrive at 12 hours and 52 minutes instead of 3 Weeks+. I didn't get a job as an accountant because they asked me to SUM 2 + 2 and when I said FIVE - they acknowledged that it was "close enough" so they gave me the job. It would be understandable if LO identified that the data doesn't fit and made automatic adjustments to masks with the appropriate "heads-up" but nobody will ever convince me that 37+27=4. Excel gets it right so besides data loss, there's the compatibility issue. -- You are receiving this mail because: You are the assignee for the bug.
