RE: [oic] TIME function in ODF vs OOXML

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

On Tue, 2012-05-22 at 21:19 -0600, Dennis E. Hamilton wrote:
> The two paragraphs that use a crude way of describing the [final] hour
> figure being taken mod 24 are in the unchanged text of OOXML.  I took
> those from the ECMA-676, Third Edition, Part 1.  This text is the same
> as in ISO/IEC 29500-1:2011 section 18.17.7.323 TIME without the
> most-recent AMD.  You can obtain either of those on-line without any
> fee.
> 
> It is clear that one needs to logically do the reductions on range
> from right to left (i.e., seconds, then minutes, then hours, where
> hours and minutes can have carries in from the units to the right).
> 
> This example confirms that, I trust:
> 
>   TIME(26,120,240) = 0.1694444444444560
> 

Well, you are probably right in your interpretation of what 18.17.7.323
was supposed to define. I always find it surprising how many of these
definitions are written in such an inprecise way.

If one just reads what is said there than for TIME(26,120,240) one gets
3 hour values and two minute values. Nowhere does it say that they
should be added and then reduced again. (Of course when one doesn't
reduce one might run into trouble with the range.)

Applied to TIME(47,60,0) I basically get 23 hours + 1 hour = 24 hours,
return serial value 1, which is till in the permissible range. But I
suspect that you are right in that that should be 0.

Andreas  

-- 
Andreas J. Guelzow, PhD, FTICA
Concordia University College of Alberta

Attachment: signature.asc
Description: This is a digitally signed message part