software

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 quot;=NOW()quot;
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.--
Regards,

Shaun C.

Thanks very much Ron - That'll work just fine.
--
Regards,

Shaun C.quot;Ron Coderrequot; wrote:

gt; Since the time zone is a Windows setting, you'll need something like Chip
gt; Pearson's time zone functions:
gt;
gt; www.cpearson.com/excel/timezone.htm
gt; (that site includes a link to a workbook you can download that contains the
gt; functions you'll need)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Shaun_Cquot; wrote:
gt;
gt; gt; Does anyone know how to determine the current time zone in Excel? - OR - How
gt; gt; to convert the time provided by the NOW() function to UTC?
gt; gt;
gt; gt; I have a s.sheet that displays the current date and time for project
gt; gt; participants based all over the world. To do this i use the quot;=NOW()quot;
gt; gt; function and calculate the other project members time by adding or
gt; gt; subtracting an ofset. The problem is that if one of the other project
gt; gt; members opens the s.sheet (say in France) the calculations are wrong as NOW()
gt; gt; always returns their local time.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Shaun C.

Since the time zone is a Windows setting, you'll need something like Chip
Pearson's time zone functions:

www.cpearson.com/excel/timezone.htm
(that site includes a link to a workbook you can download that contains the
functions you'll need)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Shaun_Cquot; wrote:

gt; Does anyone know how to determine the current time zone in Excel? - OR - How
gt; to convert the time provided by the NOW() function to UTC?
gt;
gt; I have a s.sheet that displays the current date and time for project
gt; participants based all over the world. To do this i use the quot;=NOW()quot;
gt; function and calculate the other project members time by adding or
gt; subtracting an ofset. The problem is that if one of the other project
gt; members opens the s.sheet (say in France) the calculations are wrong as NOW()
gt; always returns their local time.
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Shaun C.