[sc-issues] [Issue 69584] time values are not summed up in quick-sum
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69584 --- Additional comments from [EMAIL PROTECTED] Sun Sep 17 10:46:59 -0700 2006 --- Hi Frank, I see the point and checked it. It really works as you said! Anyway, I feel that it may be a good idea to make the quick-sum summing up cells with HH:MM:SS format and to show the result as [HH]:MM:SS. It seems to be more handy (why (quick-)summing up if the result isnt [HH]:MM:SS?) and may prevent other users from that trap. Just a proposal.. Andreas - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69584] time values are not summed up in quick-sum
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69584 Issue #|69584 Summary|time values are not summed up in quick-sum Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|amue82 --- Additional comments from [EMAIL PROTECTED] Sat Sep 16 03:45:14 -0700 2006 --- Using the sum-function in the status bar with cells which contain time values leads to unexpected values when the sum is greater than 23:59:59. Example: Cell 1: 20:00:00 Cell 2: 10:00:00 Cell 3: 06:00:00 Quicksum is: 12:00:00 I would expect a correct sum: 36:00:00 I often use this function to sum up working times to a total working time. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]