displaying only the workdays along with time in excel sheet

[priyankamakke]

I am looking for excel sheet help: creation date + no of hrs = expected due date excluding weekends eg., 11/24/2017 16:23 + 72 hrs = 11/29/2017 16:23
I tried a couple of combination with workday() in excel but no luck. can someone help?

 

[bosco_yip]

Try,




A2: 11/24/2017 16:23

B2: 72

In C2, enter formula :

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

p.s. the picture date is in UK date setting, using your own country date setting the formula result is same.

Regards
Bosco

 

[stevediaz]

Hello @
priyankamakke

To calculate the expected due date excluding weekends based on the creation date and number of hours, you can use the following formula in Excel:
=IF(MOD((A1+TIME(B1,0,0)-TIME(9,0,0)),1)>=0.5,NETWORKDAYS.INTL(A1+TIME(B1,0,0)-TIME(9,0,0),A1+TIME(B1,0,0)-TIME(9,0,0)+1,11)*1+((MOD((A1+TIME(B1,0,0)-TIME(9,0,0)),1)-0.5)/0.5),NETWORKDAYS.INTL(A1+TIME(B1,0,0)-TIME(9,0,0),A1+TIME(B1,0,0)-TIME(9,0,0),11)*1+(MOD((A1+TIME(B1,0,0)-TIME(9,0,0)),1)/0.5))
In this formula, A1 is the cell that contains the creation date and time, and B1 is the cell that contains the number of hours.
Hope it helps you. Further you can also refer this source .

 

[vletm]

stevediaz ...
priyankamakke has last seen May 23, 2019.