View Single Post
 
Old 08-26-2011, 07:01 AM
flackend flackend is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Default

I created another column, column C, with the start time + two hours formula:

Code:
=IF(A1 <> "", A1 + TIME(2,0,0), "")
Then I hid the column. Then set the data validation (list) for the end time column (column B) to this formula:

Code:
=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,1,1,1)
Which gives a drop-down list that contains only the contents of the cell one column to the right (which contains the start time + two hours).
Reply With Quote