Date/Time in different time zones

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" <jsale@tril dot cod> wrote in message
news:esUhD47DFHA.3840@tk2msftngp13.phx.gbl...
> 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
>
>

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

/Fredrik

Perfect.

Thanks.


"Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in message
news:uRVzFA8DFHA.1012@TK2MSFTNGP14.phx.gbl...
>
> "Josh Sale" <jsale@tril dot cod> wrote in message
> news:esUhD47DFHA.3840@tk2msftngp13.phx.gbl...
>> 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
>>
>>
>
> http://www.cpearson.com/excel/timezone.htm
>
> /Fredrik
>
>