Feedback by UserVoice

 

How can we improve Excel for the web? Vote for an existing idea or share a new one.

← Excel for the web

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.

68 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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.

31 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Gic Tylor commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • Asher commented  ·   ·  Flag as inappropriate

    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....

  • Roman commented  ·   ·  Flag as inappropriate

    Please, I am surprised this is actually an issue Microsoft has not addresses in 3 years, wow!!!

  • László Gacsal commented  ·   ·  Flag as inappropriate

    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.

  • Peter Grummitt commented  ·   ·  Flag as inappropriate

    Excel in Teams keeps switching date format back to Armenian and now() formula is 4 hours ahead (armenian time). I am in the UK

  • Christina commented  ·   ·  Flag as inappropriate

    I'm based in London and the timezone is 8 hours behind... so California time? Very odd!

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Brian commented  ·   ·  Flag as inappropriate

    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?

  • KK commented  ·   ·  Flag as inappropriate

    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.

  • Glenn Kr. Larsen commented  ·   ·  Flag as inappropriate

    Here is a possible workaround
    =IF(ISERROR(INFO("OSVERSJON"))=FALSE;NOW();NOW()+(1/24*A1))
    The INFO funkction is not supported in Excelonline, so if you know the amount of time difference you can ad the timeshift for Excelonline in Cell A1.Use hours in A1 for the suggested formula.
    This way the time can be correct both in the on and offline Version.

← Previous 1

Excel for the web: Formulas and Functions

Categories

Feedback and Knowledge Base

(thinking…)