Is there a macro to convert times between 2 places dep. on date?

[Guest]

I'm trying to convert times every month between my location and up to 50
locations. Depending on the date and which city/country/daylight savings
time, it is inconsistent. I've used the world time and date clock website
which is helpful, but was wondering if anyone knew of a macro or program that
would automatically calculate the time based on the date entered. I
currently maintain a schedule in excel, but was wondering if there is some
other tool that would be able to handle this.

 

[Ron Rosenfeld]

I'm trying to convert times every month between my location and up to 50
locations. Depending on the date and which city/country/daylight savings
time, it is inconsistent. I've used the world time and date clock website
which is helpful, but was wondering if anyone knew of a macro or program that
would automatically calculate the time based on the date entered. I
currently maintain a schedule in excel, but was wondering if there is some
other tool that would be able to handle this.

If you have the time zones for the different locations in a table, it should
not be a problem to convert times in Excel. It's just a matter of adding
(subtracting) the appropriate number of hours; probably using a table and
VLOOKUP.


--ron