Skip weekends

[rhhince]

I have a date in cell A1, Wed 10/07/09 18:00 and I wish to add 3 days
to it, but skip the weekend that I define as Friday at 16:00 to Sunday
at 17:00, Normally, I would put =A1+3. That would give me Sat 10/10/09
18:00. How would I do that? I should end up with Monday 10/11/09
19:00, 2 days and 1 hour added on.

 

[Herbert Seidenberg]

Excel 2007
Exclude odd weekend/time block
from days/hours calculations.
http://www.mediafire.com/file/twnumm0zoiu/10_11_09a.xlsx