Thanks for your 3 replies. Two of us have looked at your replies and are not certain how to respond. It is obvious by inspection that the difference between the two dates is NOT 1900 years.
We decided the best was to restate the human intended goal: put in two dates and times in one cell each; format the both cells MM/DD/YYYY HH:MM:SS [a non User defined format, i.e. a 'standard' format.] Now the human wants to know: "How many years, months, days, hours, minutes, seconds are there between the two?" It would seem one should be able to subtract between the two and display the results in a third cell. If so, what is the format that should be applied to third cell? If not, why? Next, to us, by the still existing uncertainty, leads credence to one of our "bug" points: there needs to be more documentation, explanation, on date and time usage and/or formats. --- On Wed, 1/21/09, Chris Cheney <[email protected]> wrote: From: Chris Cheney <[email protected]> Subject: [Bug 319187] Re: Calc-Date/Times Handled incorrectly To: [email protected] Date: Wednesday, January 21, 2009, 1:40 PM If you expand your formatting to YYYY:MM:DD:hh:mm:ss you see this: 1899:12:31:11:26:02 1899:12:31:11:26:02 1900:01:19:13:00:11 1900:01:19:13:00:11 And the calc basis date is 1899/12/30 So it looks like you are just using this format incorrectly, please follow up letting me know where you found that the D / DD code means something other than day of the month. Thanks, Chris Cheney -- Calc-Date/Times Handled incorrectly https://bugs.launchpad.net/bugs/319187 You received this bug notification because you are a direct subscriber of the bug. -- 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
