RE: [oic] TIME function in ODF vs OOXML

["Dennis E. Hamilton" <dennis.hamilton@acm.org>]

That may be old.  There is an ISO/IEC AMD that does a lot about dates and time and the transition versus "pure" case.  I've seen it but I don't recall whether TIME is touched.  I do know that examples have been touched and that might apply here.

-----Original Message-----
From: oic@lists.oasis-open.org [mailto:oic@lists.oasis-open.org] On Behalf Of Hanssens Bart
Sent: Tuesday, May 22, 2012 01:25
To: oic@lists.oasis-open.org
Subject: [oic] TIME function in ODF vs OOXML 

Hi,

Interesting, but nasty issue for implementers

* ODF 1.2, Part 2
6.10.17 TIME: ((hours*60*60) + (minutes*60) + seconds) / (24*60*60)

* ECMA 376, 3rd Edition, Part 1
18.7.7.323 TIME: TIME(26,120,240) results in a serial value of 0.169444444...


So if I read this correctly, TIME(48;0;0) in ODF has a serial value of 2, while in OOXML the value is 0


Best regards

Bart



---------------------------------------------------------------------
To unsubscribe, e-mail: oic-unsubscribe@lists.oasis-open.org
For additional commands, e-mail: oic-help@lists.oasis-open.org