How does the NOW() function get evaluated cross time zones in Excel Online?
Solution 1:
No, you can't access timezone information via VBa.
Source
However, a work around is here http://www.cpearson.com/excel/TimeZoneAndDaylightTime.aspx
You could change the time zone on your computer though as a hack!
If it's just for 1 persons time zone, and you know the difference, then could just add a N hours.
DateAdd ( interval, number, date )
EG
DateAdd("h", 1, "22/11/2003 10:31:58 AM")
would result with 22/11/2003 11:31:58 AM