In article .com,
wrote:

Also assumes NOW() always returns values rounded to whole seconds. It
doesn't.

That's apparently version-dependent. MacXL returns whole seconds, XL03
returns (approximately) hundredths.

Thanks for pointing that out - I hadn't tripped on it before.