[dba-Tech] Time values in Excel

[Rocky Smolin]

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
>