Forum Discussion
Jhnijman
Apr 01, 2020Copper Contributor
Timezone now function office 365
The Now() function in my online excel doc gives American time, while I am in Europe. How can I fix this?
Jhnijman
Apr 01, 2020Copper Contributor
JKPieterse
Apr 01, 2020Silver Contributor
In Teams, click your icon (top-right) and choose Settings. On the General tab of Settings, choose a European language such as English (United Kingdom).
- JhnijmanApr 01, 2020Copper Contributor
That defines the notation of the date and time. but not the timezone
- SergeiBaklanApr 02, 2020Diamond Contributor
These are regional setting. How to change depend on that's personal or business subscription and OneDrive or Sharepoint. However, all of them are similar. For example, if files are on Sharepoint site, click gear (settings) on top right of it, -> Site information -> View all site settings -> Site Administration -> Regional settings -> Locale -> select country
- JhnijmanApr 02, 2020Copper Contributor
SergeiBaklan That doesn't do the trick for me.
It's says there that it only effects teh notation en language. And that it does
- JKPieterseApr 01, 2020Silver ContributorApologies. More people are complaining about this: https://techcommunity.microsoft.com/t5/microsoft-teams/date-and-time-in-teams/m-p/284466