Conference Room Schedule

[geordiesenorita]

The rooms are bookable in 30 mins need an excel system where details can be put in on one tab and on the other tab if blocks out the booked room I've got a spreadsheet started but don't know where else to go regards to formula etc any help will be greatly received. Thank you in advance.

 

[EvonS]

That's unfortunate. I was messing the formula I gave you. Logically the formula should work but for some reason is seeing the times on the first and third tab as different (i.e. 8:30am on the first tab and 8:30am on the second tab). For this reason, the formula isn't working. I have not been able to figure out why. But if you can get that working, you will have a formula to us in all the boxes.