I have a spreadsheet in LO Calc (under Win 10) which shows the current time using the
NOW() function, formatted as HH:MM:SS. I also use the spreadsheet to calculate times in other time zones, which I format using, among other functions,
TEXT(SECOND(NOW()),"00"). These numbers frequently do not match when I press F9 to recalculate. When I was using 6.1.x.x, the SECOND was often one second behind NOW; I’ve recently upgraded to 22.214.171.124 and now SECOND is often one second ahead of NOW. A bit of experimentation shows that they are off from each other by maybe 0.3-0.5 seconds.
There’s not an absolute need that I have these exactly synchronized, but it is cosmetically irritating. Can anyone shed some light as to why this is happening, and how I might fix it?
Many thanks in advance.