[dba-Tech] Time values in Excel

[Stuart McLachlan]

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
>