Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2011, 12:39 PM
Deepy Deepy is offline Help with checking available times Windows 7 32bit Help with checking available times Office 2007
Novice
Help with checking available times
 
Join Date: Feb 2011
Posts: 1
Deepy is on a distinguished road
Default Help with checking available times

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?
Attached Files
File Type: xlsx New Meetings.xlsx (16.7 KB, 13 views)
Reply With Quote
  #2  
Old 02-14-2011, 05:06 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Help with checking available times Windows 7 32bit Help with checking available times Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Help with checking available times 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:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft