[dba-Tech] Time values in Excel

[Stuart McLachlan]

On 4 Jan 2024 at 18:05, Susan Harkins wrote:

> 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. 
> 
Not in my testing in Offce 2021.
You can use it for time arithmetic, subtracting time units, as long as you don't end up below 
0
Time(-2, 125,1) returns 00:05:01   
Time (2,-20,1) returns 01:40:01