Data Validation - Multiple Time Slots

vimal

Guest

Posts: n/a

13th Mar 2007

Hi Group,

I have set up an excel sheet that is used for resource booking. The
sheet basically contains columns for: Date, Start Time, End Time.

I am trying, in vain, to put in validation so that the resource is not
booked twice for the same time slot for the same day. The Start Time
and End Time contains a drop down of time (from 0800 to 1800, in 30
mins steps) and I would like the validation to be dynamic so that when
a time slot is already booked these are not available again in the
drop-down.

Grateful for any help in achieving this.

TIA

« UpdateLinks error? | Can't Get Listbox Value »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time in data validation?	=?Utf-8?B?Q3ltcm8=?=	Microsoft Excel Worksheet Functions	1	8th Jun 2005 03:52 PM
More time display options -- hide non-working hour time slots or .	=?Utf-8?B?SmF5IERlIFlvdW5n?=	Microsoft Outlook Calendar	0	12th Jan 2005 06:45 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Microsoft Excel Worksheet Functions	4	18th Nov 2004 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Microsoft Excel Worksheet Functions	0	18th Nov 2004 03:13 PM
Setting a validation rule for multiple fields at the same time	Oisin	Microsoft Access	2	17th Nov 2003 08:44 AM