Forum Discussion
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?
Check your *Windows* settings if you have chosen the correct region. The date and time format are derived from that setting.
- 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).
That defines the notation of the date and time. but not the timezone
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
