Hi!
How can i adapt this script adding a interval to lunch in 12:00 for 13:00?
Interval(
rangesum(
NetWorkDays(DT1+1,DT2-1,$(vHol)) * MakeTime(10)
// 10 hours per workday, for all day inbetween the period, excluding bounderies
,if(NetWorkDays(DT2,DT2,$(vHol)),Rangemin(rangemax(frac(DT2),maketime(8)),maketime(18))-Rangemax(rangemin(frac(DT2),maketime(8)),maketime(8)),0) // working hours last day
,if(NetWorkDays(DT1,DT1,$(vHol)),Rangemin(rangemax(frac(DT1),maketime(18)),maketime(18))-Rangemax(rangemin(frac(DT1),maketime(18)),maketime(8)),0) // working hours first day
,if(NetWorkDays(DT1,DT1,$(vHol)) and floor(DT1)=floor(DT2),-MakeTime(10)) // correct for first equals last day
)
)
as DurationStefan
Link Calculate hours between two Date/Time strings
Thanks!