I help run a coarse fishery on behalf of a charity. Normally we issue annual season tickets. Job done.
Because of the wretched Covid pandemic we like many others are having to do things very differently.
The number of people allowed on site has been reduced to permit social distancing and maintain general public safety.
We have a booking system in place which is working well. We allow 20 anglers on site on any day and they may stay on site for 12, 24, 36 or 48 hours. the start and finish times can be ignored as they are dealt with separately.
The data I have to work with is the date their permit starts and the duration. Where I'm struggling graphically is with a duration that flows into the following day. in practice each single day can have a maximum of 20 people x 24 hours = 480 hours
i.e. a 48 hour permit starts 08.00 on 1st June and runs to 08.00 3rd June. 3rd June can be ignored but I need the graph to show 1st and 2nd June as both having 24 hours taken up.
It may be that I'm totally barking up the wrong tree. what my user wants to see is how many hours are used/vacant on any given day.
any help would be most welcome