Need to convert schedule from workday to "now" or hours

HI,

Assuming Hours are in P2 then

A2:

Formula:

=WORKDAY(TODAY(),(SUM(P$2:P2,(IF(N2="Yes",3*24,P2))+(IF(O2="Yes",7*24,P2))))/24)

R2:

Formula:

=WORKDAY(TODAY(),(SUM(P$2:P2))/24)