Date/Time in different time zones

  • Thread starter Thread starter Josh Sale
  • Start date Start date
J

Josh Sale

Does anybody know how to convert the current date and time (e.g., Now) into
the date and time in (potentially) a different time zone?

For example, if the VBA code is running on a machine in the eastern time
zone or a machine in the western time zone I'd like to convert both times to
Greenwich mean time.

Thanks,

josh
 
Josh Sale said:
Does anybody know how to convert the current date and time (e.g., Now) into
the date and time in (potentially) a different time zone?

For example, if the VBA code is running on a machine in the eastern time
zone or a machine in the western time zone I'd like to convert both times to
Greenwich mean time.

Thanks,

josh
Click to expand...

http://www.cpearson.com/excel/timezone.htm

/Fredrik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing time zones 2
Macro to convert phone number to time zone 1
Return System Time Zone 3
How do I display time in gmt when my system clock is set to local 3
Time Zone Issues 3
How do you schedule a meeting in different time zone? 2
Outlook 2002 Time Zone Help 1
Date formatting in VBA 1

Back
Top