| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
 |
| | LinkBack | Thread Tools |
07-23-2004, 14:04
| #2 (permalink) |
| Civilians |  Re: Finish date minus total slack calculation That makes very little sense to me. What do you mean by a nominal date? Why would you subtract total slack? I can't think of any meaningful result that you would get by using this calculation. But nevertheless, you could use a user defined field (one of the text fields) and a formula ProjDateSub([Finish],[Total Slack]) to get the result. To set up this formula, go to insert menu choose column pick one of the text columns you aren't using right click on the column header choose customize click on the formula button enter the formula exactly as above (do not use an = sign like you would in excel) click ok -Jack "Hallie Kay" <HallieKay@discussions.microsoft.com> wrote in message news:781E5B45-33A4-43B6-B892-5FE9EFEABE57@microsoft.com... > I need to take an actual finish date and subtract the total slack to determine a nominal date. I'm not sure where to even start. > -- > Thanks. > Hallie Kay |
     |
|
07-23-2004, 15:03
| #3 (permalink) |
| Civilians | Re: Finish date minus total slack calculation Jack - Thanks so very much. That worked just fine. -- Thanks. Hallie Kay "JackD" wrote: > That makes very little sense to me. > What do you mean by a nominal date? > Why would you subtract total slack? > I can't think of any meaningful result that you would get by using this > calculation. > > But nevertheless, you could use a user defined field (one of the text > fields) and a formula > > ProjDateSub([Finish],[Total Slack]) > > to get the result. > To set up this formula, go to insert menu > choose column > pick one of the text columns you aren't using > right click on the column header > choose customize > click on the formula button > enter the formula exactly as above (do not use an = sign like you would in > excel) > click ok > > -Jack > > "Hallie Kay" <HallieKay@discussions.microsoft.com> wrote in message > news:781E5B45-33A4-43B6-B892-5FE9EFEABE57@microsoft.com... > > I need to take an actual finish date and subtract the total slack to > determine a nominal date. I'm not sure where to even start. > > -- > > Thanks. > > Hallie Kay > > > |
| |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Re: Changing calculation of total cost | Jan De Messemaeker | Microsoft Applications | 1 | 10-26-2005 14:14 |
| Free Slack calculation? | G Lykos | Microsoft Applications | 3 | 09-20-2005 04:00 |
| Re: Decimal Finish Slack | John | Microsoft Applications | 1 | 07-29-2005 00:00 |
| How do I 'start date' = current date & 'finish date' = fixed date | =?Utf-8?B?R2Vvcmdl?= | Microsoft Applications | 8 | 12-30-2004 22:00 |
| Slack and Late Finish Date | Matthew McDermott | Microsoft Applications | 16 | 06-16-2004 16:24 |
 |  |  |
