I have two dates and I want to calculate how many days, hours and minutes it is between them. The dates are 2009-12-22 16:00 and 2010-01-04 07:00, and as all of you already know it's 12 days and 15 hours between them.
But since 12 means ”12th day since 1899-12-30” the result of this calculation is 11 15:00 when formatted as ”DD HH:MM”. I didn't find a way to get around this by formatting only. For example ”0 HH:MM” didn't work. Any suggestions? ”DD HH:MM” will probably work in Excel since 0 in Excel is 1899-12-31, which also means that Calc dates are the same as Excel dates 1900-03-01 - ∞, but not before that date (Excel thinks that 1900 is a leap year). So I guess this was the reason for having 1899-12-30 as day 0 instead of 1899-12-31, right? At least it makes sense. Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
