Hi all,
I know the title doesn't describe the problem well so let me try to explain:
I need to design a table that allows me to track the usage of meeting rooms. I need to know how many times the room is used in a day and by whom. For example, Room 1 can be used between 10am and 1pm by team 1 and then used again between 2pm and 4pm by team 2. I need the table to cover every work day of the month. At the moment I have a table that has days of the month across the top and room numbers along the side. When a room is used, a 1 is placed in the table and then all the 1's are added up. What my table fails to do is to capture rooms that are used by two or more different teams each day.
Does any one have any idea how I can capture that?
Bookmarks