SOLVED

Excel Booking Spreadsheet

Copper Contributor

I am trying to sort out a booking spreadsheet for our sports club with the following data:

name start time duration

namestart timeduration
Alf14:0002:00
Bert14:0002:00
Chas14:3001:00
Dave14:3002:30
Evie16:0002:00
Frank16:0002:00
Gina16:3003:00
Harriet16:3003:00
 

The attached sheet shows the time chart I have created but I would like it to show the number of people booked in at any particular time.Capture.JPG

 

4 Replies
best response confirmed by alexp66 (Copper Contributor)
Solution

@alexp66 

I used a simple formula to calculate this:

=SUM((F1>B2:B9)*(F1<B2:B9+C2:C9))

 

Is this what you are looking for?

@TheAntony 

 

Thats great Antony. Is there any way this could be modified to show the #people booked in column L ie against the times - I could then chart number booked against time. Its all a covid thing that we have to limit numbers to under 30 and have a record of them.  Thanks for your help it is much appreciated as it took me an age to get this far (technophobe)!!!!

Don't worry, have sorted it - thank you.

@alexp66 

Here's a version with the number of people in each slot and who they are:

TheAntony_0-1593688700345.png

 

1 best response

Accepted Solutions
best response confirmed by alexp66 (Copper Contributor)
Solution

@alexp66 

I used a simple formula to calculate this:

=SUM((F1>B2:B9)*(F1<B2:B9+C2:C9))

 

Is this what you are looking for?

View solution in original post