EVERY spreadsheet where the "=NOW()" formula is used - the time is hour behind..

%3CLINGO-SUB%20id%3D%22lingo-sub-1918859%22%20slang%3D%22en-US%22%3EEVERY%20spreadsheet%20where%20the%20%22%3DNOW()%22%20formula%20is%20used%20-%20the%20time%20is%20hour%20behind..%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918859%22%20slang%3D%22en-US%22%3E%3CDIV%3EEVERY%20spreadsheet%20where%20the%20%22%3DNOW()%22%20formula%20is%20used%2C%20the%20time%20is%20one%20hour%20behind%20on%20the%20spreadsheet.%26nbsp%3B%26nbsp%3BAll%20the%20machines(users)%20are%20macs.%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1918859%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1919029%22%20slang%3D%22de-DE%22%3ESubject%3A%20EVERY%20spreadsheet%20where%20the%20%22%3DNOW()%22%20formula%20is%20used%20-%20the%20time%20is%20hour%20behind..%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1919029%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F797856%22%20target%3D%22_blank%22%3E%40Cisco905%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20don't%20know%20about%20Mac%2C%20but%20if%20you%20allow%20me...%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture%20please.%3C%2FP%3E%3CP%3EExplain%20your%20problem%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
EVERY spreadsheet where the "=NOW()" formula is used, the time is one hour behind on the spreadsheet.  All the machines(users) are macs. 
2 Replies

@Cisco905 

 

I don't know about Mac, but if you allow me... if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture please.

Explain your problem in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

 

@Cisco905 

- are files kept locally, or on network share, or in cloud?

- is computer time correct?