[dba-Tech] Time values in Excel

[Susan Harkins]

Short int supports negative values, but the TIME() arguments don't -- I
should've mentioned that -- sorry! If you use any value less than 0 or
greater than 32767, the function returns an error. 

Susan H. 

Historical. That function has been around since the days of 16 bit.  So when
written  16 bit integer (aka C Shorts)  parameters and arithmetic were the
most efficient. 
There has been little call to update the function since.

(Actually, they are not  0 and 32,767, to are -32768 to 32,767, with the
proviso that when evaluated the result must be 0 or positive or it returns
an errror  


On 4 Jan 2024 at 15:47, Susan Harkins wrote:

> Can someone please explain the significance of the maximum value of
> 32,767 in TIME(). All three arguments, hour, minute, and second, can
> be a value between 0 and 32,767. There's no time significance that I
> know of that's represented by 32,767. It's the maximum value of a
> short int value, but why would that be included in this function? 
> 
> 
> 
> Anyone know? 
> 
> 
> 
> Susan H.  
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com