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 | 14:30 | 01:00 |
| Dave | 14:30 | 02:30 |
| Evie | 16:00 | 02:00 |
| Frank | 16:00 | 02:00 |
| Gina | 16:30 | 03:00 |
| Harriet | 16:30 | 03: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.
4 Replies
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.
