Help with checking available times

Deepy · #1 02-14-2011, 12:39 PM

Hi,

Im working to develop a very simple meeting booker in excel. However, I have some problems to check if a new meeting time is conflicting with earlier booked meetings. (the structure is attached in the post)

Do you have any suggestions?

Colin Legg · #2 02-14-2011, 05:06 PM

Hi,

Put this formula in G5 and fill down:

Code:

=(COUNTIFS($D$5:$D$100,">="&D5,$D$5:$D$100,"<"&E5)+
    COUNTIFS($D$5:$D$100,"<"&E5,$E$5:$E$100,">"&D5))<=2

You can also simplify the formula in C5 (if you still want it)

Code:

=COUNTIFS($D$5:$D$24,"<="&A5,$E$5:$E$24,">="&A5)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2010 not checking for new mail	beentold	Outlook	7	02-13-2011 11:11 AM
How to skip the credential checking step	charleslt1900	Outlook	2	08-19-2010 04:02 PM
Checking ref # status based on sheet2 ref #.	aligahk06	Excel	1	04-26-2010 11:22 PM
Checking for DOS executions	ajetrumpet	Excel	0	12-06-2009 02:33 PM
Checking for data corruption in Word	mart12	Word	0	12-18-2008 03:27 AM