#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Time Zones


Can anyone tell me how i can determine what time zone a computer is in.
I have a spreadsheet that works with multipule time zones and I need t
be able to tell what time zone the computer that is running th
spreadsheet is in so i can make the right calculations on the rest o
the time zones

--
Steve
-----------------------------------------------------------------------
SteveC's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=26140

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Time Zones

This article shows you how to read (and set) the timezone.

http://support.microsoft.com/default...42&Product=vb6
HOWTO: Change Time Zone Information Using Visual Basic

--
Regards,
Tom Ogilvy


"SteveC" wrote in message
...

Can anyone tell me how i can determine what time zone a computer is in.
I have a spreadsheet that works with multipule time zones and I need to
be able to tell what time zone the computer that is running the
spreadsheet is in so i can make the right calculations on the rest of
the time zones.


--
SteveC
------------------------------------------------------------------------
SteveC's Profile:

http://www.excelforum.com/member.php...o&userid=14517
View this thread: http://www.excelforum.com/showthread...hreadid=261409



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
Formula to convert time zones?? Anna Excel Discussion (Misc queries) 3 April 4th 23 10:47 AM
Help with identifying time and time zones in a formula Mr BT[_2_] Excel Worksheet Functions 1 May 21st 09 05:23 AM
time zones Cactus-747 Excel Discussion (Misc queries) 1 April 14th 06 06:11 AM
Does Excel support Time Zones? Aaron Excel Worksheet Functions 1 March 11th 05 06:17 PM
adding time zones to formatting tjb Excel Worksheet Functions 0 February 17th 05 03:39 PM


All times are GMT +1. The time now is 06:29 AM.

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"