times are changed to negative in zoho sheet (community post)

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


(I filed a ticket on this also).

            Zoho Marketing Automation
                    • 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 :

                    Zoho Pagesense Resources

                      Zoho SalesIQ Resources

                            Zoho TeamInbox Resources

                              Zoho DataPrep Resources

                                Zoho CRM Plus Resources

                                  Zoho Books Resources

                                    Zoho Subscriptions Resources

                                      Zoho Desk Resources

                                        Zoho Projects Resources

                                          Zoho Sprints Resources

                                            Qntrl Resources

                                              Zoho Creator Resources

                                                Zoho WorkDrive Resources

                                                    Zoho Campaigns Resources

                                                      Zoho CRM Resources

                                                            Design. Discuss. Deliver.

                                                            Create visually engaging stories with Zoho Show.

                                                            Get Started Now