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)
Bookmarks