I'm using data validation instead of a formula directly in the cell because I want the user to be able to enter a time other than 2 hours later without having to erase the formula.
I attached my spreadsheet. I'm just wondering if there's a way to have whatever the first item in the data validation drop-down list be selected automatically.
|