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.

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).

Sticky Posts
Do more with Zoho Docs
Hello Everyone, Thanks for participating in our live webinars, posing questions and giving feedback. We look forward to having you with us in the next live webinar from Zoho Docs. This webinar will help you learn how to: Set up your organization profile Create organizational policies Organize files for easy access Work together on files for improved productivity Assess performance with activity reports Create appealing content with the Zoho Office Suite Day : Thursday, 8th February 2018 Time :

Topic Participants