On Sun, 8 Jun 2008 15:57:28 -0700 (PDT), Eric wrote:

Let say is Friday at 8:00 PM. I want to add 7 hours to it and skip all
hours in Saturday and Sunday. Start adding calulating again at Monday
at 12:00 AM (Monday Morning). Any help in this would be appricated. I
have reviewed and reviewed things trying to figure this out.

Eric


Try this:

=WORKDAY(A1+TIME(A2,,)-1,1)+MOD(A1+TIME(A2,,),1)

with Date and time in A1; and the number of hours to add in A2

This formula is the same:

=WORKDAY(A1+A2/24-1,1)+MOD(A1+A2/24,1)

--ron