Need formula for

QuestionEdit

i need your help to putformula for, I am trying to prepare training room bookingwhere i want formula which can tell me about time booked if its free then free otherwise booke.

IF i you can send me your email id , will love to send that sample file to you, which will help you to understnad what exactly i am looking for

Ganesh

AnswerEdit

The principle seems easy enough, though I suspect there will be problems in that if you want a room from 2pm for one hour and it's booked from 2:30 for half an hour, it's not available - so it's not just a question of checking the start time! However, happy to help if I can - my email is aidan.heritage@virgin.net