Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Project Time | Excel Worksheet Functions | |||
Multiple user time collection by project and dates? | Excel Discussion (Misc queries) | |||
Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
Project over time stacked bar chart | Charts and Charting in Excel | |||
Time calculation problem (URGENTProject due) | Excel Discussion (Misc queries) |