LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Project Time Tammy H Excel Worksheet Functions 1 June 7th 08 02:20 AM
Multiple user time collection by project and dates? Darren Excel Discussion (Misc queries) 0 August 29th 07 03:44 PM
Running Total for Time Spent for a project in 1 month Chart_Maker_Wonderer Excel Worksheet Functions 5 March 8th 07 06:41 PM
Project over time stacked bar chart The WB Charts and Charting in Excel 1 January 9th 07 09:01 AM
Time calculation problem (URGENTProject due) g6pack Excel Discussion (Misc queries) 4 November 28th 05 04:14 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"