working hours

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

anyone :-(

Meanwhile you can check this result that DonkeyOte solved for me:

http://www.excelforum.com/excel-gene...ly-report.html

Look at post number #11
This also take in consideration public holidays etc... You can change hours at the INFO sheet

Originally Posted by zbor

Look at post number #11
This also take in consideration public holidays etc... You can change hours at the INFO sheet

Thank you for the link, I'll definitely look at this link while waiting for a response from 6StringJazzer

Originally Posted by 6StringJazzer

I will post later if I have an update but I won't be able to look at it again until Monday

Thank You,
I will wait ;-)