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
Hi Mourad,
Strange. For O365 E3 under the Language setting do you mean Locale?
And where did you find such date/time format, here is only one option 12/24 hours format
We speak about OneDrive site settings, correct?
As for the personal O365 - yes, all settings are under your account setting. Here they have no option for the locale, the only way to change it is to change your country.
Hi Sergei, Hi Wyn
@Sergei: in Office365 E3-Plan, I have the following as shown in the screenhsot, when I go to my profile.
In OneDrive (Personal Free Account, no Office365), I have only the possibility to choose my country.
----------------------------
@Wyn: thanks! I have found it. I went to one of my Sharepoint sites (where an Excel Online file loads in) and found the regional settings, which were set to UTC-08:00 PST (Pacific Standard Time, US).
I agree, that's a pain to change all sites. As user I would have expected to have my settings override them. But I am not a Sharepoint expert.
Best,
Mourad
Mourad,
Strange, i'm also on E3 but have different interface
Anyway, doesn't matter. Back to Wyns' question, as i know Excel online on business subscriptions doesn't care about your personal account settings, it works in accordance to site settings.
Okay, bit more. I dind't test, but probably that could help.
Go to Admin Center -> Sharepoint -> user profiles
Under the People click Manage User profieles
Find yourself and under drop down menu (it's not obvious it is here) select Edit profile
In huge list of settings find this one
Chnage on Always use personal setting, click Only me, after that page refreshes and you may select desirable locale for this concrete user. Perhaps some other settings to chnage some way.
Sure you have to have admin rights for all that stuff. Again, i didn't test how that will affect Excel behaviour.