You need something like this it appears, however this doesn't expand the single digit numbers to double digit:
=CONCATENATE(PROPER(TRUNC(DAYS(B1;B4);0));":";PROPER(HOUR(DAYS(B1;B4)));":";PROPER(MINUTE(DAYS(B1;B4)));":";PROPER(SECOND(DAYS(B1;B4)))) Wow that was ugly... :-) There may be an easier way but I've never had the need to try to do this before. I used proper to convert the numbers into text, but there may be some better way to do this. Feel free to file a request at the official OpenOffice.org bug tracker for an automated way to format this. Do any other spreadsheets do this automatically? Or do they just use different basis dates to make it look like it works? If so you could file the report as a compatibility issue with the other spreadsheet application. http://www.openoffice.org/issues/query.cgi Chris ** Changed in: openoffice.org (Ubuntu) Status: Incomplete => Invalid -- Calc-Date/Times Handled incorrectly https://bugs.launchpad.net/bugs/319187 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
