Forum Discussion
Solved
Excel Booking Spreadsheet
I am trying to sort out a booking spreadsheet for our sports club with the following data: name start time duration name start time duration Alf 14:00 02:00 Bert 14:00 02:00 Chas ...
I used a simple formula to calculate this:
=SUM((F1>B2:B9)*(F1<B2:B9+C2:C9))
Is this what you are looking for?
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)!!!!