GMT date & time

[mike]

Hi
Can someone tell me how to save the current GMT date & time into a cell?
The reason I use GMT is we have daylight saving here and I would like the
time to be independent of daylight saving.

 

[Paul Lautman]

Hi
Can someone tell me how to save the current GMT date & time into a
cell? The reason I use GMT is we have daylight saving here and I
would like the time to be independent of daylight saving.

See http://www.cpearson.com/excel/timezone.htm for details of how to get UTC

 

[MartinW]

Hi Mike,

First you need to know your timezone and variation from GMT, a google
search will find that pretty easily.

Using my timezone as an example which is GMT + 10
In A1 I put =NOW()-"10:00"

During daylight saving
I will put =NOW()-"11:00"

HTH
Martin

 

[mike]

Thanks Paul. This is exactly what I needed.
Also, thanks MartinW for your information.