Determining current Time Zone In Excel

S

Shaun_C

Does anyone know how to determine the current time zone in Excel? - OR - How
to convert the time provided by the NOW() function to UTC?

I have a s.sheet that displays the current date and time for project
participants based all over the world. To do this i use the "=NOW()"
function and calculate the other project members time by adding or
subtracting an ofset. The problem is that if one of the other project
members opens the s.sheet (say in France) the calculations are wrong as NOW()
always returns their local time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting time into another time zone 4
Time zones in recurring meetings 2
Calculating the Time In A Time Zone 1
How can I calculate and show Multiple Time Zones for tasks 2
Get Appts to display in current time zone? 1
How do I add 24 hours to a date and time value formated cell? 4
All day events and time zone 10
Need to determine where a change in table occurs 6

Top