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?
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