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.
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
Peter Grummitt commented
Excel in Teams keeps switching date format back to Armenian and now() formula is 4 hours ahead (armenian time). I am in the UK
I'm based in London and the timezone is 8 hours behind... so California time? Very odd!
I have the same problem and it is plain that excel online is working on GMT time
If a spreadsheet is uploaded to Microsoft Teams and have been formatted in a current time zone or area code. DO NOT default it back to US. And once uploaded, keep that date or time format so when new entries are made in teams access to the spreadsheet it does not format back to a default US position screwing up all new date or time entries.
New Years Eve 2019, over 2 years since original post and MS is still has yet to fix a simple issue with a big impact nor provide any real advice to fix with formulas. MS also has yet to fix their support for excel online which makes no sense since desktop works perfectly fine. Why is there such a feature gap between the two?
Let me repost here, 2 year passed, there is still no fixes,
I have called MS online support and they asked me to post to MS community.