time difference between PC and excel

[graiggoriz]

hello,

In my macro I use the below format to get date and time. Though the time is the same as my PC time setting.I have few minutes of difference.

Please Login or Register  to view this content.

Many thanks,
Graig

[karedog]

Hi,

You use wrong identifier for minute. You can see, you use the same "MM" identifier both for month [("DD-MM-YY")] and also minute [Format(Now, "MM")].

The correct identifier for minute is N character, you can read them all here in microsoft site :
https://msdn.microsoft.com/en-us/lib.../gg251755.aspx

So, for your case, the right statement is :

Please Login or Register  to view this content.

Regards

[graiggoriz]

Gr8 Thanks!

[shg]

Or just

Please Login or Register  to view this content.