networkdays I think with formula

  • Thread starter Thread starter brettsouth
  • Start date Start date
B

brettsouth

Hi one and all

I have a spread sheet which supplies operational Machine hours vi
various formulas which result in run time and machine set up times.
I wish to use these time from a planned starting date say for exampl
26th May start with a run time and set up that equals 15 days total.
How can do I provide a formula that takes this operation from star
date and adds the total run time with set up but excludes weekends an
holidays, working on an eight hour day and supplies an end date an
time?

ie Sart date +( set up time + run time) =End Date & time based on a
eight hour day;) :confused:

Thanks to all that can hel
 
Do you mean

=WorKDAY(start_date, ROUND((setup+run)/8,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top