hi,
i have the following formula to calculate the difference in days, hours, minutes, seconds between 2 dates (excluding the weekends and the holydays).
=IF(NETWORKDAYS(A3+1,B3-1)<0,0,NETWORKDAYS(A3+1,B3-1))+IF(WEEKDAY(A3,2)>5,0,1-(A3-TRUNC(A3)))+IF(WEEKDAY(B3,2)>5,0,B3-TRUNC(B3))
the A3 in...