| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to convert time zones?? | Excel Discussion (Misc queries) | |||
| Help with identifying time and time zones in a formula | Excel Worksheet Functions | |||
| time zones | Excel Discussion (Misc queries) | |||
| Does Excel support Time Zones? | Excel Worksheet Functions | |||
| adding time zones to formatting | Excel Worksheet Functions | |||
Threaded Mode
