G
GEM
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??
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??