Bug 64435

Summary:	SUM of Cells (hh:mm ... hh:mm) is wrong !?
Product:	LibreOffice	Reporter:	Karl <JKluth>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	gerard.fargeot
Priority:	medium
Version:	4.0.3.3 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Karl 2013-05-10 15:51:00 UTC

I do have a spreadsheet where i note my 

daily work ( Hours, Minutes ) , fx: 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.
where as the result is of what is left.



Bug or Feature ?

Example of column:
------------------

04:00
08:00
12:30
07:00

"SUM" calculates: 07:30 (which is 31:30 minus 24:00)

i would expect: 31:30

regards
karl

Comment 1 GerardF 2013-05-10 17:21:07 UTC

For hours > 24:00, format cell "[hh]:mm"

Not a bug.