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

Reply via email to