Columns C and D use validation drop-downs to figure out the time to place in Column E . This has turned out to be a somewhat confusing process that I am hoping to simplify.
I would prefer to replace the drop-down validation of both columns with a single column that allows the UTC offset (such as -5 or -6) to be input manually. One would simply 'type' instead of 'select' the number +6, -5, +3 or whatever manually, and the time could populate properly.
The sheet is editable by anyone and assistance is greatly appreciated.