Hourly Employee Head Count and Staffed Rooms

Are the employee shifts of tech and nurse shifts always the same?
If so OK. If not so, please attach an example of different shifts, for example with 4 nurses and 2 techs.

If a shift ends at 7.45 PM it should count for 0.75 at 7 PM.
If a shift starts at 6.15 AM should that also count for 0.75 at 6 AM?
In your example it counts for 1.

Assuming 1 Tech and 1 Nurse needed to staff a room

This makes it difficult. Are the equal or nearly equal shifts of a nurse and tech always together?
Can there also be shifts of a tech without a corresponding shift of a nurse or vice versa?

Would it be acceptable if the formula only takes into account the shifts of the nurses or only takes into account the shifts of the techs?
If that is the case, then realizing a working formula is a lot easier.

Thanks for your answers. That is enlightening.

I do have a question about entering the times of a Shift.
Looking at your examples, 7:00 PM can be entered in 12 different ways. 7PM, 7:00PM, 7:00:00PM, 7 PM, 7:00 PM, 7:00:00 PM and all these variants with a P instead of PM.

That is difficult to interpret by Excel.
It would be easier if the start time and end time of the shift in 2 different cells would be entered directly in a correct time format and if incorrectly entered times could be stopped via validation.

Here is a short video with an example: https://www.youtube.com/watch?v=6pvYWbmx3cw

I feel that before we can attempt to propose a formula/code that will give the headcount, we need to see how you are going to fill the employee shift column(s) as stated in post #7.
Let us know if you have any questions.