Conference Room Schedule

geordiesenorita

New Member
Joined
Mar 8, 2018
Messages
7
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You can probably accomplish this with an IF statement. For example =IF(tab1room1="", "Available", "Already Booked") where tab1room1 is the cell reference that contains the value pertaining to the room booking. This formula would be used on the 'other' tab. Hope this helps.
 
Upvote 0
Hi thanks for your advice, so would it work to block out hours in the day rather than the whole room. I'm a bit rubbish with formulas but like to learn. So if you think wish I could link the file made so could describe it. Like what I want in effect is a calender that shows certain rooms at certain hours booked x thanks in advance ?
 
Upvote 0
Hi thanks for your advice, so would it work to block out hours in the day rather than the whole room. I'm a bit rubbish with formulas but like to learn. So if you think wish I could link the file made so could describe it. Like what I want in effect is a calender that shows certain rooms at certain hours booked x thanks in advance ?

Yes a link to the file would be helpful.
 
Upvote 0
I was wondering if you could please help me with a project my boss has tasked me with. He wants me to make a excel spreadsheet (maybe a gannt chart from googling ideas) showing rooms booked (10 rooms) for a variable duration throughout the day (from 8am until 6pm for variable times I.e. 30 mins, 2 hours, 4.5 hours etc) for example room 1 may be booked from 9am-3pm by one person and then 3.30pm - 4.30pm on the same date by another, and then for it to show on what would look like a calendar with that person's name in the booking... I suggested using outlook but my boss said that his boss wants the information to be reportable, so it must be in excel. I know a few tricks in excel but I'm a novice (my boss knows this) so I am turning to the power of the Internet and you talented bunch of individuals as any advice on helping me create this would be greatly appreciated. I have a starting point of the spreadsheet which I have on Google drive. This is a work in progress, Any suggestions? Thank you all in advance. Link to file of Google drive is : https://drive.google.com/folderview?id=1bPTqBpt3KJnvU7FgTuem320h-Ew4Flb0
 
Upvote 0
I took a quick look at your file. On your 'MAR' tab, you can either use conditional formatting and/or use something like the following formula in the appropriate cells =IF(AND(LISTS!G1="Booked",C2=LISTS!C1),"X",""). This formula will check if an item has been booked and if the booked time corresponds with the column the formula is in. If both arguments are true, it will place and "X" in the box. Otherwise it will leave it blank. Additionally, you can use conditional formatting to change the colour of the box whenever an X appears for better aesthetics. Excel formulas are very exact so I suggest using a drop down list for bookings on your "LISTS" tab. I I hope this helps.
 
Upvote 0
I took a quick look at your file. On your 'MAR' tab, you can either use conditional formatting and/or use something like the following formula in the appropriate cells =IF(AND(LISTS!G1="Booked",C2=LISTS!C1),"X",""). This formula will check if an item has been booked and if the booked time corresponds with the column the formula is in. If both arguments are true, it will place and "X" in the box. Otherwise it will leave it blank. Additionally, you can use conditional formatting to change the colour of the box whenever an X appears for better aesthetics. Excel formulas are very exact so I suggest using a drop down list for bookings on your "LISTS" tab. I I hope this helps.

Thank you, I'll give that a try today and get back to you. Will that take the information from the bookings? Do you think each month separate or a year along the top? Sorry if I'm behind a nuisance I just don't know what would be best (we'll Outlook would be best but was told must be excel
��)...
 
Upvote 0
What's best really depends on your needs. My organization uses outlook for room and equipment books and it works great. An Excel sheet will take a while to make. Why does your manager want excel to be used?
 
Upvote 0
What's best really depends on your needs. My organization uses outlook for room and equipment books and it works great. An Excel sheet will take a while to make. Why does your manager want excel to be used?

Hi Evons I could not get the formula to work :( I've had a chat with my boss and he said for it to look like a Calender and block out the times per room on a sheet in excel, I said again about outlook but he said it must be in excel as that's what his boss wants. This is so frustrating :/ all I can imagine is a tab that looks like a daily calendar per hour per room, another tab with the booking information and to save the spreadsheet as a template to be used either daily or weekly. I'm utterly at a loss.
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top