Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shaun_C
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Shaun_C
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Used as a Time Sheet emanna Excel Discussion (Misc queries) 6 March 2nd 06 06:25 PM
can excel be a time clock or stop watch? Anthony Reynard Chinnis New Users to Excel 1 February 15th 06 07:51 AM
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
How to enter current static time in Excel in 00:00:00.0 format? Wlumkong Excel Worksheet Functions 3 May 12th 05 03:54 PM
Accumulate weekly time to total time in Excel. delve Excel Discussion (Misc queries) 0 May 4th 05 08:14 PM


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"