I am currently using a calculation from an older post to calculate end date time using a start date time and a duration. This formula excludes weekends and accounts for a 18hr production day.
WORKDAY(L6,CEILING((M6+MOD(L6,1)-F$2)/G$3-F$2),1)-1+MOD(L6,1)+M6-CEILING(MOD(L6,1)+M6-F$2,G$3-F$2)+G$3-F$2
L6= Start Date time
M6= Duration
N6= End Date time
E2= Production start time 6:00am
G3= Production end time 11:00pm
My question is I want to exclude a "break" from 2pm to 4pm. How would I include this into my current formula.
WORKDAY(L6,CEILING((M6+MOD(L6,1)-F$2)/G$3-F$2),1)-1+MOD(L6,1)+M6-CEILING(MOD(L6,1)+M6-F$2,G$3-F$2)+G$3-F$2
L6= Start Date time
M6= Duration
N6= End Date time
E2= Production start time 6:00am
G3= Production end time 11:00pm
My question is I want to exclude a "break" from 2pm to 4pm. How would I include this into my current formula.
