How to calculate time elapsed but ignore weekends

J

Jami1989

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.
 
R

rowiga

Jami1989 said:
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.
Click to expand...

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

Jami1989

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.

rowiga said:
Jami1989 said:
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.
Click to expand...

try: DateAdd("w",3,[DateReceived])
Click to expand...
 
Top