Forum Discussion
What is the basis of =NOW() time that shows in Excel Online
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.