Removing non business days & hours & lunch break

I found this older topic that answers a good part of my issue but one still remain.

I have to adjust it so it so in addition to ignoring the non working days and non working hours it also ignores the midday break : 12:00-13:00

Currently I've tweaked my formula to this


=(NB.JOURS.OUVRES(C3;C4)-1)*("17:30"-"13:30"+"12:00"-"08:30")+SI(NB.JOURS.OUVRES(C4;C4);MEDIANE(MOD(C4;1);"17:30";"08:30");"17:30")-MEDIANE(NB.JOURS.OUVRES(C3;C3)*MOD(C3;1);"17:30";"08:30")


With C3 my starting date and C4 my ending date and NB.JOURS.OUVRES being the french equivalent to NETWORKDAYS and SI replacing IF

I've managed to adjust the first part of the calculus on the whole days part but I'm stuck with the other half of the formula.

If someone had a clever idea I'd be really grateful

Thanks in advance

Thanks ! Great ! I'll be testing that right now !

Works perfectly ! Many thanks !