Joe Conner wrote:
I believe cell A2 is behaving correctly. ... The math is correct. It is just user error to understand what is being shown. Garbage in = garbage out.
I agree: the error is in not understanding how Calc (and Excel, AFAIK) handles dates and times internally. You might say it is an error that Calc exposes this internal detail, but I think it would be foolish to go that far, especially when the internals are so simple.
Dates are stored as floating point number of days since Dec 30, 1899. Integral dates correspond to 0:00 (midnight).
Times are stored as floating point fraction of one day (24.0 hours): Midnight is 0; noon is 0.50.
The only thing that distinguishes dates and times from any other numeric value is their formatting on input and display.
This means that the DAYS function is just another name for "-", and your problem examples are simply subtracting two numbers where one or both are expressions, as Joe C has demonstrated.
<Joe --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
