https://bugs.freedesktop.org/show_bug.cgi?id=64433
Priority: medium
Bug ID: 64433
Assignee: [email protected]
Summary: Calculation of "SUM" of a colomn of "times"
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.3.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 79103
--> https://bugs.freedesktop.org/attachment.cgi?id=79103&action=edit
Simple Spreadsheet, Wrong SUM (time) calculation
Hi,
I do have a spreadsheet where i note my
daily work ( Hours, Minutes ) , fy: 06:45
where all the cells of the column are formattet hh:mm.
If I add a "SUM" for all the "times" below all the "times"
the calculation of "SUM" is allways a "modulo 24:00" - operation.
Bug or Feature ?
Example of column:
------------------
04:00
08:00
12:30
07:00
"SUM" calculates: 07:30
i would expect: 31:30
regards
karl
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs