For an estimated end time taking into account NO production on Sunday and the lengths of breaks, try this formula:
Disclaimer: This formula does take into account the length of the daily breaks, but does not take into account when those breaks are exactly. However, the formula takes into account exactly when it is Sunday.Formula:
=LET(nd,H4/J4/24/(1-SUM(O3:Q3)+SUM(O2:Q2)),t,WORKDAY.INTL(C4,nd,11)+MOD(nd,1)+MOD(C4,1),t+(WEEKDAY(t)=1))
Bookmarks