Forum Discussion

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Apr 18, 2017

What is the basis of =NOW() time that shows in Excel Online

When I publish to Excel online my =now() formula displays a time 13 hours behind local Perth Time (Australia)    Question1:  Any way to force the display in Local Perth time?   Question2:  When I...
Excel Online
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 30, 2019

markh1325 

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)

markh1325's avatar
markh1325
Copper Contributor
Sep 30, 2019

SergeiBaklan 

 

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

  • haithammalak's avatar
    haithammalak
    Copper Contributor
    Dec 16, 2019

    markh1325 

    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

Resources