I have a schedule template that allows me to see how many people I have working each hour. However, the formula breaks when I have someone working across midnight. Can someone take a look and see how I might modify this to make it work appropriately?

count workers per hour.xlsx