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 Desk Resources

                            • Desk Community Learning Series

                            • Digest

                            • Functions

                            • Meetups

                            • Kbase

                            • Resources

                            • Glossary

                            • Desk Marketplace

                            • MVP Corner

                            • Word of the Day

                                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 :

                                        Manage your brands on social media

                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources

                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources

                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources

                                                            Zoho Sprints Resources

                                                              Qntrl Resources

                                                                Zoho Creator Resources

                                                                  Zoho WorkDrive Resources

                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series

                                                                      • Tips


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Digest


                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now