RE: [oic] TIME function in ODF vs OOXML

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

On Tue, 2012-05-22 at 19:10 -0600, Dennis E. Hamilton wrote:
> I just checked the latest AMD for OOXML that I know about.  John is
> correct.  The only changes to the TIME function are to replace the
> phrase "serial value" with the term "serial date-time" (now introduced
> earlier in the strict specification).  
> 
> In unchanged text, OOXML strict says that truncated-hour mod 24 is
> used as the hour value, truncated-minutes over 59 will be changed to
> the corresponding number of hours and minutes, and truncated-seconds
> over 59 are converted to the corresponding number of hours, minutes,
> and seconds.  There's a prospective edge case in here, but I suspect
> hours are transformed to range 0 to less than 24 when it is all done.
> 
> The Return Type and Value are still a number, but its value is 0 <=
> result <= 1.  The only way to get to 1 is apparently via rounding.
> Parameters are out of range if less than 0 or not less than 32768.  

Hi Dennis,

where can I find this AMD? I am asking because reading this either there
are a whole bunch of mathematical no-ops here or the result value could
be outside the range 0 to 1.

Andreas

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

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