Jirka <[EMAIL PROTECTED]> writes:
Dobrà den,
tady si dovolÃm vloÅit konverzaci Pavla s erAckem, kterà vzniklÃ
problÃm vysvÄtluje.
(17:16:15) paveljanik: erAck: byt anyway: enter 83:20:10 to A1.
(17:16:34) paveljanik: =day(A1) returns 2 in OOo 3 in Excel.
(17:16:45) paveljanik: this was reported on [EMAIL PROTECTED] list.
(17:26:07) erAck: paveljanik: Excel converts the input to
1900-01-03T11:20:10, any value below 1.0 (==24h) results in
1900-01-00; any more questions? ;-)
(17:26:53) paveljanik: erAck: I do not have any question, in fact, the
only one is why the result is not the same
(17:27:12) erAck: paveljanik: because Excel calculates wrong.
(17:28:08) paveljanik: thanks
(17:32:40) erAck: paveljanik: using their serial date value schema
a value less than 1.0 should be 1899-12-31; we use that as
0-date, because in Excel 1900 erroneously is a leap year,
so dates before 1900-03-01 are off with one day.
(17:34:08) paveljanik: erAck: I think we should "popularize" this
issue
(17:36:44) erAck: paveljanik: dates in Excel are quite limited, you
can't even calculate days before 1900-01-01, or 1900-01-00
that is ;-)
(17:39:28) erAck: paveljanik: also negative time values aren't
possible, neither as input nor as a calculation elapsed
time result
--
Robert Vojta
http://blog.vojta.name/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
