I have read multiple threads on here with time calculations, but I cannot seem to get any of them to work with my situation.

We need to calculate the amount of production time between 2 cells with the below criteria.

1st Shift starts at 6:30
1st Shift ends at 15:30

2nd Shift starts at 16:30
2nd Shift ends at 1:00 (the next day)

I would also like to be able to specify holidays - these have a tendancy to change based on our production progress.

Below is what I have - but I think that the fact that my second shift passes midnight, it does not work. The below also does not take into account the hour break in our shifts.

Any help would be greatly appreciated!!

A1 = Start Date/Time (dd,mm,yyyy hh:mm)
B1 = Stop Date/Time (dd,mm,yyyy hh:mm)
C1:C5 = Holidays

=(NETWORKDAYS(A1,B1,$C$1:$C$5)-1)*OR("00:00" - "01:00","00:00"-"06:30")-MOD(A1,1)+MOD(B1,1)