To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41259 Issue #:|41259 Summary:|Values coming from condition-functions cannot be used |with HOUR Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|loony
------- Additional comments from [EMAIL PROTECTED] Tue Jan 25 01:32:42 -0800 2005 ------- C4=IF(F4="Test";"18:00";"06:00") D4=IF(F4="Test";"06:00";"18:00") F4=Test E4=(HOUR(C6-D6)*60+MINUTE(C6-D6))/60 Result for E4 (format number '0,00'): 0,00 Result for E4 should be: 12,00 When using conditions the resulting values cannot be used with time-functions. Tested version of OOo: 1.9.71.1 (Linux, PC) --------------------------------------------------------------------- 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]
