Assuming your schedule times from A1:A100

What you can do is to define a named range.

go insert-name-define

Type a ranged name like "TestRange" and reference it to A1:A100

In the cell which you want to validate using a List,

Click Allow:List

Source: =TestRange

And presto. done

--
KellTaine
-----------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...fo&userid=3432
View this thread: http://www.excelforum.com/showthread.php?threadid=54905