leighjones123
New Member
- Joined
- Aug 12, 2011
- Messages
- 49
- Office Version
- 365
- Platform
- MacOS
Hi all. Looking for some help with a formula to do what I need... For whatever reason, I can't seem to find the right COUNTIFS.
In ColA I have a start time (for a booking)
In ColB is the end time
I'm trying to create a table which shows me how many bookings are active within the times set.
My data example...
My required table (with the end result)...
Just to add context... this is to help me to see how many tables are in use within my restaurant at what times... so I can effectively plan staffing.
Unfortunately, my booking system doesn't automatically give me the data I need.
I've been able to work out how to find out how many tables/customers are arriving within a particular time window... but this doesn't tell me exactly how many total customers I've got in the restaurant within a particular time window.
Hope anyone can help
Best
Leigh
In ColA I have a start time (for a booking)
In ColB is the end time
I'm trying to create a table which shows me how many bookings are active within the times set.
My data example...
Start Time | End Time | Booking Name |
12:00 | 14:00 | Mr A Smith |
12:30 | 14:30 | Mr B Smith |
13:00 | 15:00 | Mr C Smith |
16:00 | 18:00 | Mr D Smith |
My required table (with the end result)...
Start Time | End Time | Bookings Active |
12:00 | 12:29 | 1 |
12:30 | 12:59 | 2 |
13:00 | 13:29 | 3 |
13:30 | 13:59 | 3 |
14:00 | 14:29 | 2 |
14:30 | 14:59 | 1 |
15:00 | 15:29 | 0 |
15:30 | 15:59 | 0 |
16:00 | 16:29 | 1 |
16:30 | 16:59 | 1 |
17:00 | 17:29 | 1 |
17:30 | 17:59 | 1 |
Just to add context... this is to help me to see how many tables are in use within my restaurant at what times... so I can effectively plan staffing.
Unfortunately, my booking system doesn't automatically give me the data I need.
I've been able to work out how to find out how many tables/customers are arriving within a particular time window... but this doesn't tell me exactly how many total customers I've got in the restaurant within a particular time window.
Hope anyone can help
Best
Leigh
Last edited: