Hello, i have the formula to calculate between two dates but the result is uncorrect or error if i put the start/ time out of business hour.
Please help me and hope get solutions...
This is my formula
=(INT(I11)-INT(H11)-INT((WEEKDAY(H11-1)+INT(I11)-INT(H11))/7)-SUMPRODUCT((J2:J3>H11)*(J2:J3<I11)*(WEEKDAY(J2:J3)<>1)))*(I2-H2)+MOD(I11,1)-MOD(H11,1)
Explanation :
I11 = EndDate
H11 = StartDate
J2:J3 = HolidayList
I2 = EndTime
H2 = StartTime
Bookmarks