Forum Discussion

alexp66's avatar
alexp66
Copper Contributor
Jul 02, 2020
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 ...
excel
  • TheAntony's avatar
    TheAntony
    Jul 02, 2020

    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?

alexp66's avatar
alexp66
Copper Contributor
Jul 02, 2020

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)!!!!

alexp66's avatar
alexp66
Copper Contributor
Jul 02, 2020
Don't worry, have sorted it - thank you.

Resources