Time Zone

[HR157]

What formula I can use to make the changes of hour between cities or
continents?

What formula I can use to make the changes of hour between cities or
continents?

 

[Guest]

=A1+(1/24*3)

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

You really need a table of cities/continents and the time adjustment, and
look it up using VLOOKUP.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)