Posted to microsoft.public.excel.programming

external usenet poster

Posts: 18

Return System Time Zone

I am creating an application that will be used by users in both the US
and India.

There is a cell in my worksheet that I want the Current Date, the
Current Time, and Time Zone of the user to output to.
-For example, in cell A3, I want the macro to output 12/8/06 4:05PM
(CST). I know how to get the current system date and time (using the
Now function), but how do I return the system time zone?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 to return system time when I press combination of keys	Nagendra	Excel Worksheet Functions	2	September 25th 07 10:38 PM
convert time from one zone to other zone in excel	ram	Excel Worksheet Functions	1	April 25th 07 01:24 PM
Time Zone..	Trevor M	Excel Discussion (Misc queries)	1	April 10th 06 08:49 AM
Time zone using VBA	ged	Excel Programming	0	October 25th 04 05:29 PM
Time zone using VBA	ged	Excel Programming	1	October 20th 04 05:25 PM

All times are GMT +1. The time now is 02:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us