Forum Discussion
Stillworkingonit
Nov 05, 2019Copper Contributor
One Drive/excel online wrong time zone
Hello, Excel online =Now() is bringing in a different timezone. My account information on my office 365 account is correct. Anyone else have this issue and have a fix? Thank you!
Abiola1
Nov 06, 2019MVP
Hello,
To solve the problem, kindly follow the steps below to change the Time Zone
1. From OneDrive, select the gear icon beside the ?
2. Select Site Settings
3. Under Site Administration, select "Regional Settings"
4. Select the Time Zone that is peculiar to your Region
5. Click OK
Next time you use the NOW function is Excel, it returns the desired date and current time.. I hope this helps
Regards
To solve the problem, kindly follow the steps below to change the Time Zone
1. From OneDrive, select the gear icon beside the ?
2. Select Site Settings
3. Under Site Administration, select "Regional Settings"
4. Select the Time Zone that is peculiar to your Region
5. Click OK
Next time you use the NOW function is Excel, it returns the desired date and current time.. I hope this helps
Regards
ahmed-meal-
Feb 14, 2022Copper Contributor
Hi dear
I tried the steps that you were mentioning but I couldn't get any setting when I clicked on the setting gear, I only found "Third party notice" under that as you can see in the picture below, do you know the reason for that?
Thanks in advance
- SergeiBaklanFeb 14, 2022Diamond Contributor