I'm devising a schedule worksheet, for which I want to automatically
calculate hours as data are entered. Considering using drop down lists for
data input, but the options for any one category of type of workday (for
example, "AE") needs to have options for hours scheduled placed after the
"AE" (e.g. "AE 0800-1600") and the beginning and ending hours could be
anything in a 24 hour period. There are mutliple types of workday symbols
(e.g. "AE", "HP", "HA" etc.).
Is there a way to construct a drop down list, such that the user can access
the prefix to the work schedule entry (i.e. AE) and then add the appropriate
hours by typing in the hours. In other words, a drop down list that the user
can modify the entities of the list.