View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PD PD is offline
external usenet poster
 
Posts: 18
Default Project End Time

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