https://bugs.documentfoundation.org/show_bug.cgi?id=149139
Bug ID: 149139
Summary: Calculation with time duration is not simple, it is in
Mac Numbers.
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I've cut and paste some track times from MusicBrainz to get the following,
7:23
3:50
2:28
5:21
2:46
8:05
3:07
9:56
With SUM(A0:A7) I get this.... which is obviously not the answer anyone would
expect.
00:00.00
Now the same in NUMBERS for Mac...
7m 23s
3m 50s
2m 28s
5m 21s
2m 46s
8m 5s
3m 7s
9m 56s
---> SUM(A0:A7) gives the correct answer, with no headache.
42m 56s
It shouldn't be difficult in LibreOffice, there's a lot of people who want to
make a simple duration calculation. Without my Mac I would be going nuts
trying to get LibreOffice to do the right thing. I'd probably give up and use
python/pandas
Steps to Reproduce:
1. write some durations into a column with [m]m:ss.sss format
2. sum the column
3. stare in disbelief and the incomprehensible result.
Actual Results:
Shown above from Mac NUMBERS
Expected Results:
Shown above from Mac NUMBERS
Reproducible: Always
User Profile Reset: No
Additional Info:
Should have been more flexible in reading time durations
--
You are receiving this mail because:
You are the assignee for the bug.
