[dba-Tech] Time values in Excel

[Daniel Waters]

I think this is hardware related (or was back in 1995).  2^15 = 32768 - which is 1 more than 32767.

Beyond that it might be some deep ancient MS knowledge.

Good Luck!

-----Original Message-----
From: dba-Tech <dba-tech-bounces+df.waters=outlook.com at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: 4 January, 2024 14:48
To: 'Discussion of Hardware and Software issues' <dba-tech at databaseadvisors.com>
Subject: [dba-Tech] Time values in Excel

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