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.
I have taken the requested steps to "fix" this problem, however, it did not work. See screenshots. Post 2 of 2
I have taken the requested steps to "fix" this problem, however, it did not work. See screenshots. Post 1 of 2
IM HAVING SAME PROBLEM WITH WRONG EST US CANADA TIME PLEASE FIX
@Admin Still not fixed. My local time is April 1 2021, 0834.
=NOW() in Excel on OneDrive shows March 31 2021, 2204 which is UTC I believe.
Using NOW() in Excel Online still gives me UTC time, not local time. Opening the same workbook via the Android app or desktop app gives local time instead. The workbook file's created/modified dates in OneDrive show correct local time as well.
This is still a problem in excel office365
I am in +10 timezone, formula TODAY() returns yesterdays date
Muhammad Ali commented
This isn't fixed for Personal Onedrive, as mentioned by other comments, the regional settings aren't present for us.
Thank you Gic Tylor!
It works: "you' have to go Sharepoint regional settings on the One Drive site".
Date and time should reflect the correct timezone.
[Deleted User] commented
I can't fix this. I have right time on my outlook still =now() is 2h behind in gmt-0.
Gic Tylor commented
To fix this problem, you' have to go Sharepoint regional settings on the One Drive site, and set the right time zone.
Peter M commented
3 years this problem?! embarrassing for a startup to get this wrong, this is a basic function. Microsoft what are you doing with your life
Hi, I am from Central Europe and the problem is urgent here as well!!!!
Needs to be fixed, so problematic for formulas that rely on knowing the date. I'm in Australia at UTC+10, so the error is a full 17 hours - my spreasheet doesn't know what day it is....
Please, I am surprised this is actually an issue Microsoft has not addresses in 3 years, wow!!!
Mario Di Noia commented
MS Please fix urgently needed
unbelieveable! it's been 3 years and this bug still exists!
László Gacsal commented
Solution: (work for me)
- Setup the one-drive time zone:
OneDrive web page -> Gear on the top right corner -> One drive setup -> Additional settings -> Regional Setting -> Time Zone
- Setup the SharePoint page time zone, where you store the excel file:
Sharepoit team web page -> Gear on the top right corner -> Web Page properties -> All Properties -> Localization settings -> Time Zone
After this two modification excel online works as expected.
=TODAY() is giving 04/05/2020 still even though time is 05/05/2020 9:51