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]

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.

 

[geordiesenorita]

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 ?

 

[EvonS]

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.

 

[geordiesenorita]

I don't know if I did this right but I'll attempt to share the link to the file. I saw that a previous question had been asked similar to mine and a member advised spreadsheetzone.com but I think the site has been taken down *sad face* https://drive.google.com/folderview?id=1bPTqBpt3KJnvU7FgTuem320h-Ew4Flb0

 

[geordiesenorita]

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

 

[EvonS]

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.

 

[geordiesenorita]

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
�&#56900...

 

[EvonS]

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?

 

[geordiesenorita]

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.