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
Joseph Geretz's avatar
Joseph Geretz
Copper Contributor
Apr 18, 2018

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.

markh1325's avatar
markh1325
Copper Contributor
Sep 30, 2019

Joseph Geretz 

 

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.

  • 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

  • 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

  • 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)

Resources