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

Shaun C.


"Ron Coderre" wrote:

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

http://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-Pro


"Shaun_C" wrote:

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.


--
Regards,

Shaun C.