View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Drop down list & Time Zones.

Let's see if I get myself understood...

A1= cell to imput a time number, for example 11:00 AM
B1= Drop down validation, with Pacific Time, Mountain Time, Central Time,
Eastern Time.

Basically user enters time and selects which time zone this time represents.

A3=The time A1 represents in Pacific Time
B3=The time A1 represents in Mountain Time
C3=The time A1 represents in Central Time
D3=The time A1 represents in Eastern Time

How can I get A3, B3, C3, D3 to do this automatically, by letting the user
just enter a time number and its corresponding time zone??