working hours

[Dumy]

I'm looking for the solution of problems on the forum, but I have no success

I tried several kinds of combination of functions and formulas, but I have no successful results
I try to create a table that contains data on working hours in three shifts (first shift, second shift, third shift). Working hours range from 0 to 24 hours

I've created an entire table and some formulas we operate. I've defined the name of most of the original data and use them in formulas.
I have a problem, as the data to calculate how many hours in which the working shift. My formulas are too long

I want to calculate using a formula (not through the macro)

Can anyone help me
Thank you in advance