Automatically sorting event totals by hours

[johnsey_salt]

I'm a relative newbie to the power excel world, so don't know if this is possible or not.

I have

1 field that indicates the number of attendees
1 field that indicates start time
1 field that indicates end time.

What I would love to automate is to have individual fields for the hours of the day (starting with 7am, ending with 5) with a sum total of attendees that were present during each hour.

Here are screenshots to make this clear.

What I have:


-- removed inline image ---




What I want:


-- removed inline image ---

 

[johnsey_salt]

What I have:


-- removed inline image ---




What I want:


-- removed inline image ---