Project End Time

  • Thread starter Thread starter PD
  • Start date Start date
P

PD

Hi,

I've looked everywhere and can't find an answer for this one..
I am trying to calculate what time a task will finish, however it needs to
be quite exact with differing operating hours mon-fri than sat-sun. Is there
any way to do this?

Info Example:

Start - 09:00 mon 18/5/09
Duration - 60 hrs
Mon-fri hrs work - 10hrs (each day)
Sat-sun - 3hrs (each day)

= projected finish time 13:00 25/5/09

Also, this is a repeatable task, so if possible would like to drag this
formula down and calculate when, for example, the tenth would finish

Many thanks in advance for any help you can give
 
Hi Herbert,

Thanks for the response, however my Excel is version 2003 and while your
link does open and seem to work (i.e. defined names are all there) the
"Accum" list and Finish box all have #VALUE error. When I change the Accum
list to a {} Ctrl+Shift+Ent formula, it warns of a circular reference. This
looks exactly like what I need though, do you have any suggestions ?
 
Hi Herbert,

Thanks for the response, however my Excel is version 2003 and while your
link does open and seem to work (i.e. defined names are all there) the
"Accum" list and Finish box all have #VALUE error. When I change the Accum
list to a {} Ctrl+Shift+Ent formula, it warns of a circular reference. This
looks exactly like what I need though, do you have any suggestions ?
 
In Excel 2003
MRound() does not work with arrays.
Take it out of the "Accum" formula
and it will work most of the time.
"Accum" is not entered as an array formula.
Apply the defined name "Accum" manually.
 
In Excel 2003
MRound() does not work with arrays.
Take it out of the "Accum" formula
and it will work most of the time.
"Accum" is not entered as an array formula.
Apply the defined name "Accum" manually.
 
Back
Top