Need help trying to quantify hours scheduled per hour

I have a schedule that I imported into excel from my business server. I need to find a formula or create one that will give me a breakdown of the number of people scheduled per hour. Their shifts vary throughout the day. Any help would be appreciated.