Adding days to Date/Time and exclude weekends

[helpwexcel]

Hello Everyone,

I need help and appreciate everyone's expertise.

I have a date with time, need to add number of days, exclude weekends. Results should show Date with Time.

A2 = Jul 8, 2016 10:30:06
B2 = 2.917 days

I tried this: WORKDAY(A2,b2)
Result: 7/12/2016 0:00:00

Need results to consider the start date/time.

Thanks for your help.

 

[Weazel]

if i'm understanding correctly and you just need the time from A2 added back to the date then maybe...

=WORKDAY(A2,B2)+MOD(A2,1)

 

[helpwexcel]

if i'm understanding correctly and you just need the time from A2 added back to the date then maybe...

=WORKDAY(A2,B2)+MOD(A2,1)

Thank-you Weazel.

I tried putting the time back in. 2.917 days is 70 hours

Results = 7/12/2016 10:30:06
But should be 7/12/2016 8:30:06

 

[Tetra201]

2.917 days is 70 hours... But should be 7/12/2016 8:30:06

Shouldn't it be 7/13/2016 8:30:06?

13.5 hrs on 7/8/2016
24 hrs on 7/11/2016
24 hrs on 7/12/2016
8.5 hrs on 7/13/2016
for a total of 70 hrs

 

[helpwexcel]

Thanks Tetra201.

It should be 7/13/2016 8:30:06

Now how do we make Excel show that.

 

[Weazel]

I'm sure theres a better way but maybe....

=MOD(A2,1)+MOD(B2,1)+WORKDAY(A2,B2)

 

[helpwexcel]

I'm sure theres a better way but maybe....

=MOD(A2,1)+MOD(B2,1)+WORKDAY(A2,B2)

Thanks so very much Weazel. It worked!

 

[Tetra201]

I'm sure theres a better way but maybe....

=MOD(A2,1)+MOD(B2,1)+WORKDAY(A2,B2)

Just to mention: the above formula stumbles over some data pairs, for example:
12/21/2016 23:45:00 and 2.2, or 12/19/2016 08:30:00 and 4.7.

Here is the formula that works:

=WORKDAY(A2,B2+MOD(A2,1))+MOD(A2+B2,1)