Employee Count Per Interval

I need some help again. (I had a previous thread in here on the same topic)

I have 2 files now - the first one (called OU Template) takes the "shift bid" and breaks it down into 2 cells and then calculates the OU. That one is working properly.
The second one (called OU) takes the shifts in 2 cells already, calculates the OU, and then spits out the shift bid with the times put together.

Firstly, the OU file isn't calculating like the OU template is. It's not doing the formulas properly including overnights. And it has to go Sunday into Monday as well as this more of a "rolling week" template not for specific dates.

Secondly, we have some situation where an event might occur from 3:45-5:45 and it isn't calculating that as .5 on the OU, it's marking it as a 1 which is not correct since it's only half of the time.

Can someone tell me how to fix these?

Thanks!