TIME function in ODF vs OOXML

[Hanssens Bart <Bart.Hanssens@fedict.be>]

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