One Drive/excel online wrong time zone

%3CLINGO-SUB%20id%3D%22lingo-sub-984059%22%20slang%3D%22en-US%22%3EOne%20Drive%2Fexcel%20online%20wrong%20time%20zone%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-984059%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EExcel%20online%20%3DNow()%20is%20bringing%20in%20a%20different%20timezone.%26nbsp%3B%20My%20account%20information%20on%20my%20office%20365%20account%20is%20correct.%26nbsp%3B%20Anyone%20else%20have%20this%20issue%20and%20have%20a%20fix%3F%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-984059%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-984669%22%20slang%3D%22en-US%22%3ERe%3A%20One%20Drive%2Fexcel%20online%20wrong%20time%20zone%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-984669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421533%22%20target%3D%22_blank%22%3E%40Stillworkingonit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20change%20regional%20settings%20for%20OneDrive%20on%20web.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-985916%22%20slang%3D%22en-US%22%3ERe%3A%20One%20Drive%2Fexcel%20online%20wrong%20time%20zone%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-985916%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20solve%20the%20problem%2C%20kindly%20follow%20the%20steps%20below%20to%20change%20the%20Time%20Zone%3CBR%20%2F%3E1.%20From%20OneDrive%2C%20select%20the%20gear%20icon%20beside%20the%20%3F%3CBR%20%2F%3E2.%20Select%20Site%20Settings%3CBR%20%2F%3E3.%20Under%20Site%20Administration%2C%20select%20%22Regional%20Settings%22%3CBR%20%2F%3E4.%20Select%20the%20Time%20Zone%20that%20is%20peculiar%20to%20your%20Region%3CBR%20%2F%3E5.%20Click%20OK%3CBR%20%2F%3E%3CBR%20%2F%3ENext%20time%20you%20use%20the%20NOW%20function%20is%20Excel%2C%20it%20returns%20the%20desired%20date%20and%20current%20time..%20I%20hope%20this%20helps%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

4 Replies

@Stillworkingonit 

You need to change regional settings for OneDrive on web.

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

@Abiola1 

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

ahmedmeal_0-1644835174432.png

 

@ahmed-meal- 

Now for Excel for web that's File->Options->Regional Format Settings

image.png