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?
JKPieterse
Apr 01, 2020Silver Contributor
Check your *Windows* settings if you have chosen the correct region. The date and time format are derived from that setting.
Jhnijman
Apr 01, 2020Copper Contributor
- JKPieterseApr 01, 2020Silver ContributorIn 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