How to calculate time elapsed but ignore weekends

[Guest]

I have a Date Received column and I need to add 72 hours to the [date
received]. I do not want to include the time between 8:00 pm Friday evening
and 7:59 AM Monday morning....and excluding holidays would be a bonus - but
I'd be happy with just eliminating the weekends.

 

[Guest]

I have a Date Received column and I need to add 72 hours to the [date
received]. I do not want to include the time between 8:00 pm Friday evening
and 7:59 AM Monday morning....and excluding holidays would be a bonus - but
I'd be happy with just eliminating the weekends.

try: DateAdd("w",3,[DateReceived])

 

[Guest]

This does not work....it only adds 3 days to the Received Date - the
complication comes in when I have to stop counting at 8:00 pm Friday and
begin counting again at 7:59 am Monday morning. By eliminating weekends - I
should have been more specific....I actually need to eliminate the above
mentioned time.

I know the code used to do the above is quite extensive......I have seen it
used before.....I just do not have access to it, and was hoping someone might
be able to help.

Thanks anyway....much appreciated.

I have a Date Received column and I need to add 72 hours to the [date
received]. I do not want to include the time between 8:00 pm Friday evening
and 7:59 AM Monday morning....and excluding holidays would be a bonus - but
I'd be happy with just eliminating the weekends.

try: DateAdd("w",3,[DateReceived])