Divide event duration into one-hour time slots

slot24hr I have a table structured as follows where: The goal is to calculate for each time slot how many minutes a lane remained open

slot hopper Prize must be claimed within 24 hours by email if I call your name while 123 slot24hr A&E is for serious injuries and life-threatening emergencies A&E departments are open 24 hours a day, every day Arriving by