[dba-Tech] Time values in Excel

[Susan Harkins]

I thought perhaps it was some such. I know there's a lot of date arithmetic going on under the hood. However, I don't think Excel nor VBA support a short integer, so I wonder if it's a compatibility issue? 

Seems arbitrary. 
Susan H. 


Here’s my semi-educated guess:

32767 is the largest number you can fit in a 16 bit word. When designing a function like that, I imagine you have to decide how big the numbers are that the function is going to work with and program the function to work with that range of values.

Hth

R

On Thu, Jan 4, 2024 at 12:47 PM Susan Harkins <ssharkins at gmail.com> 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