Forum Discussion
What is the basis of =NOW() time that shows in Excel Online
That's useful. I'm thinking there is some risk around some users experiencing different dates if the today() or now() formula is used in the file. That's the issue I came across yesterday. Thanks for your help
I am also having trouble with this. I'm using an Office365 subscription which gives me free OneDrive. So I am often working on documents from different locations - at my office or at the client, etc. So I use OneDrive. It's very handy.
I usually use the locally installed Office applications but today I gave a shot at the option to just open my excel workbook - it's a timesheet - online. I noticed that the last entry - which is coded to use Now() if timeout hasn't been punched - shows over hours of work, even though I've just punched in at 9:30am. I figured it's a timezone thing and confirmed it by entering =Now() into a cell and seeing the time. Sure enough - it's 12:16pm here, but the time I get back is 4:16pm! (Goody - almost time to go home! ;-)
I checked my account setting - the timezone is set properly. Is there any fix for this? I won;t be able to use Excel online if I can't relay on it to execute relative to my timezone.
i have the same issue from along time, when i reffer to microsoft with many troublshooting over last 4-5 month, and nothing solved.
now i'm searching for somthing to give me the timezone for specific country. or to have somthing to get the timestamp from a list i create.
any Idea will Help
many thanks
Haitham Malak
Thanks for the one drive settings. Not sure how I missed those. This appears to have fixed the formula in Excel online
I already had all the sharepoint settings set to UTC + 12 =now() =today() still getting wrong timezone in Sharepoint
If we speak about OneDrive for Business,
Click Settings
Here More settings->Regional settings
and set your timezone within it.
For Sharepoint Site
Settings gear->Site Information->View All site settings (at the bottom of the pane)->Regional settings (under Site Administration group)
Hi Joseph
Did you ever find an answer to this problem? I am having the same issue with this formula in both Excel and Sharepoint online =now() and =today() both insist on displaying in PST when ALL my regional settings are set to UTC+12
There must be a global tenancy default somewhere but damned if I can find it.
