Help with checking available times

		Microsoft Office Forums > Microsoft Excel > Excel
Help with checking available times

02-14-2011, 05:06 PM

Colin Legg Colin Legg is offline

Windows 7 32bit Help with checking available times

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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)

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:05 AM.