Automatic, Dependent Cell Values

		Microsoft Office Forums > Microsoft Excel > Excel
Automatic, Dependent Cell Values

08-26-2011, 07:01 AM

flackend

Windows XP Automatic, Dependent Cell Values

Office 2003

Novice

Join Date: Aug 2011

Posts: 6

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).

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dependent drop down lists in Word 2007	benbenasc	Word VBA	0	08-24-2011 06:34 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
How to create a Dependent Drop-Down Picklist	ComcoDG	Word	2	03-17-2009 07:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.