times are changed to negative in zoho sheet (community post)
When I enter a time, like, say 6:55am, zoho sheets used to put 06:55:00 in the cell.
That's how it worked yesterday 11/14/2021.
Today, 11/15/2021, zoho sheets puts -17:-05:00 in the cell.
That's negative 17 and negative 05.
-17
-05
as if it's the time before midnight tonight, rather than the time since midnight this morning.
https://i.imgur.com/4RJ4h5D.png
If I format as number, it is -0.71, ie negative 0.71.
I have times in a template and when I use that template to create a spreadsheet, the times from the template are still positive.
So subtracting negative times from positive times give the wrong answer as a duration.
And when I saved a sheets document to a file and open it with LibreOffice the times come through as all 12:00am ie 0 (zero).
And when I import a document from LibreOffice the times are correctly "06:55:00".
example:
(I filed a ticket on this also).