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).
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
john v. kumpf
Shaun Jude O Brien
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 :
New to Zoho TeamInbox?
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 Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー