Timezone now function office 365

Question

The Now() function in my online excel doc gives American time, while I am in Europe. How can I fix this?

jkpieterse · Answer

Check your *Windows* settings if you have chosen the correct region. The date and time format are derived from that setting.

jhnijman · Answer

JKPieterse&nbsp;Thanks, but no, in this case they are not. I shared the file in Teams.&nbsp;&nbsp;

jkpieterse · Answer

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

jhnijman · Answer

That defines the notation of the date and time. but not the timezone

jkpieterse · Answer

Apologies. More people are complaining about this: https://techcommunity.microsoft.com/t5/microsoft-teams/date-and-time-in-teams/m-p/284466

Forum Discussion

Timezone now function office 365

8 Replies

Resources