Forum Discussion
What is the basis of =NOW() time that shows in Excel Online
Hi Wyn, Hi Sergei,
as I am curious about an answer for Wyn's questions too, I checked it on my accounts.
On my E3 Office365 account, I have in my profile the settings Language = German, Timezone = (UTC+01:00) Amsterdam, Berlin, Rome, ... and as date and time format dd.mm.yyyy hh:mm. If I create a new Excel file within Office 365, I'll get for =NOW() the value 19.04.2017 04:50. However, it's 13:50 actually. So, the time is wrong. I don't know, if I have to change more settings too in Office 365.
On my private OneDrive account, I get 19.04.2017 12:50. So, the daylight hour is forgot and this is also wrong. I checked several options on my private OneDrive account and did not find settings for that. However, it's also a little bit confusing there, as there are e.g. settings for the OneDrive Language, my Language and Excel shows me formulas in English (Browser).
Best,
Mourad
So, I had to change the settings as Sergei suggested, however my files were in Sharepoint Online rather than OneDrive
So I had to go the Sharepoint site page that I needed to change and go to the cog.
It appears to be that you have to do this for each individual site (which is a pain).
Then Site Information followed by view All Site Settings, after that it's Regional Settings.
Wyn, maybe it's worth to ask SPO people in there community if it's possible to change regional setting for entire site collection at once. If not from UI perhaps they know some magic powershell script.
At least there is no option for entire tenant so far, see https://office365.uservoice.com/forums/273493-office-365-admin/suggestions/6835268-tenant-wide-time-zone-setting-for-sharepoint-at-l
The reason is the tenant people could be distributes among time zones/regions and they have to have the ability to adjust setting for their sites.
