Scenario:

I need to determine the peak periods in which passengers are getting on to a tour bus. I have the times in which people are getting on and how many people at those specific times. I need to be able to determine the maximum number of people with in a one hour time frame for different peaks during the day (ie. am, midday, pm and night).

- must find the range of cells for one hour time frame
- use the same range of cells for that one hour time frame to sum the number of passengers to find which hour has the most number of passengers


Is this possible and if so please help, I have been trying and have had no luck and have become very frustrated.


snap.png