To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114653 Issue #|114653 Summary|perform calculations on sum of 24-hr clock-time number |s OR convert same to decimal Component|Formula editor Version|1.0.0 Platform|Other URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|mru Reported by|ezehkef
------- Additional comments from ezeh...@openoffice.org Tue Sep 21 14:40:51 +0000 2010 ------- I use a 24-hour clock to keep track of hours spent on a task so that I can use the math function to subtract start-time from end-time. I need a way to then translate this sum to decimal time OR to multiply the sum by a decimal number (rate) example: "clock time" =sum(13:00-9:00) => 4 which is easy to convert to decimal but "clock time" =sum(12:43-8:15) => 4hrs 28min is not easy to convert I need to be able to multiply this daily and weekly, without rounding, and have not found any formula to do so. Thank you. --------------------------------------------------------------------- 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: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org