10
How does EXCEL ONLINE evaluate the NOW() function when a spreadsheet is accessed from different time zones? For example, if user PAUL is in London, UK and accesses a sheet at 5PM GMT and user SUE is in NY and accesses the sheet at 1PM ET, what time is displayed for each of them in a cell where the formula is =NOW()?
Is there anyway to set the NOW() function to a specific timezone time?
user329661
Posted 2014-06-05T13:20:09.520
Reputation: 101
1
No, you can't access timezone information via VBa.
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
Dave
Posted 2014-06-05T13:20:09.520
Reputation: 24 199
This article from CPearson covers how to convert a system's local time to GMT, which is what I would use in this case (of requiring the use across multiple timezones). That way the timecodes have a GMT offset of 0:00 and the times can be converted locally to the appropriate time. – Breakthrough – 2014-06-05T13:44:06.237
Is there a way to convert a system's local time to GMT without VB? I have no idea what I'm doing in that environment. – user329661 – 2014-06-06T00:12:18.027