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

[Dawn Clark]

I have a attached a schedule that I need to improve. (the only relevant tab is "Eastern, and I have made the affecting formula header black and the input time in red)

What i need to do is instead of utilizing "projected run time in days" (Column P) , I need this to be in hours (or even minutes). Hours are preferred. The problem i have had is that I cannot get the intended dates in column A & R because they are based on workday function. Hours were always preferred but using Workday & Today for this schedule was all I was able to achieve thus far. Please note that columns N & O also contribute to this equation.

So to summarize, I need:

Column A & Column R (Projected finish /delivery dates) need to have the same results as current (or can include time and minutes) except that I need it to be based on hours or minutes entered into Column P (Run time)

[AliGW]

How are you currently calculating the number in P?

[AliGW]

OK - I see now (I think).

If P2 is in hours, them this in A2:

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

If P2 is in minutes, then this in A2:

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

[Richard Buttrey]

HI,

Assuming Hours are in P2 then

A2:

Please Login or Register  to view this content.

R2:

Please Login or Register  to view this content.

[Dawn Clark]

Column P is manually entered by operators

[Richard Buttrey]

Column P is manually entered by operators

Indeed, that's what I understood since that's what you mentioned in your OP.

[Dawn Clark]

Thanks so much! This worked