rkhokilaa
June 30th, 2008, 02:37 AM
Hi All,
I need a formula which excludes week ends and night times especially (8PM - 8 AM EST). Any one can help on this? Thanks in advance. I am using the formula for excluding week ends is follows.
DateDiff ("h",d1 ,d2 ) -
DateDiff ("ww", d1, d2, crSaturday) * 24 -
DateDiff ("ww", d1, d2, crSunday) * 24
I need a formula which excludes week ends and night times especially (8PM - 8 AM EST). Any one can help on this? Thanks in advance. I am using the formula for excluding week ends is follows.
DateDiff ("h",d1 ,d2 ) -
DateDiff ("ww", d1, d2, crSaturday) * 24 -
DateDiff ("ww", d1, d2, crSunday) * 24