Allow the time and date to be corrected or the time zone to be adjusted in Excel Online
Not so much an idea as a fix. MS should make it so you can correct your timezone (time and date) within Office Online so time and date related formulas are correct.
Hey all, we’d to share that we’ve fixed the time zone on Excel for the Web workbooks to be the time zone taken from the operating system, instead the time zone taken from the host account.
Following your feedback, we understood that the main pain is the difference between the host time zone (that was set previously for Excel for the Web) and the OS time zone (that applies for Excel desktop app).
Now, the time zone will be adjusted to be the same as in your device.
This new capability is supported in SharePoint Online, OneDrive and Exchange hosts.
Thank you for voting and influencing our priorities. Keep voting for other ideas you want us to address.
Thanks, Excel team.
Michelle Slater commented
October 2019, still an issue and as it has been outstanding for several years I think not an MS priority.
This has real business impact when =TODAY() is used in formulas - I only happened to notice the discrepancy by accident. I was using it to calculate and highlight which of our tickets were approaching their SLA date expiry, to ensure we closed those tickets by the day prior to reaching their SLA. If I had not noticed the issue, we would have missed all of our SLAs. This bug has the potential to have real-world monetary impact. It's completely unacceptable that it is not being resolved.
Agree. Please fix!
June 2019, still no fix.
This is a huge issue for me too, and I am incredibly frustrated by it. For $100 a year, I should be getting a product that can manage time zones in a browser. The time zone change ruins formulas for me using the =Today() function and =now() function.
This is an incredible oversight.
Big fan of desktop version but for on-the-go access, it is bad that time zone settings do not work out of the box, and even worse that this is not easily changed from the workbook itself.
If this can't be figured out, I'll eventually just have to go back to Sheets.
Clifton Hodges commented
I'm having the same problem as well on the TIME ZONE issue on EXCEL ONLINE, which makes things look freaky to anyone that I want to share a spreadsheet with, thus I resorted to Google Sheets which let's me set the UTC/GMT setting; at least for now, since EXCEL ONLINE is not useful with showing different dates and times from each other (manually entered ones verses the formula ones)/
Vitor Canova commented
Still a bug. My Outlook.com settings are correct but the "Now" function is off by hours.
Nabeel Moeen commented
same issue, it's more of a bug than a feature request.
Hi Bhaskar Raj, I am using a similar solution as you, but this is not an elegant solution. :(
Bhaskar Raj commented
The online workbook is probably picking the server time where as if you open the online workbook in local then it picks up your local system time zone.
Currently I have to create two formulas , one for online calculation and one incase if the file is downloaded and opened in local !!
Yes MarthaQ, I am experiencing the same issue but ONLY on the desktop. The mobile Android app shows the correct date and time. When viewing the same worksheet. Annoying.
I believe this Microsoft error emerged recently due to some Microsoft update maybe on a server. My time zone has been set correctly in all settings but the excel online Now() and Today() functions display UTC or GMT time in Excel Online rather than my actual time zone.
In my case (EST), this means that any workbook using Now() or Today() appears to show tomorrow's date if I view the workbook after 7pm . I do not want to make compensating formula adjustments if someone is going to fix this soon and I would then have to reverse my formulas.