Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining current Time Zone In Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining current Time Zone In Excel
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining current Time Zone In Excel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Used as a Time Sheet | Excel Discussion (Misc queries) | |||
can excel be a time clock or stop watch? | New Users to Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) |