Formulas in Project

[Stuck Contractor]

I am working on a schedule and I need to show days of Float on a seven day
work calendar while keeping the working time on a five day calendar. The
only way I see to do this is to create a new formula. I am not sure how
these formulas are put together. I am pretty good in Excel, but am lost at
this.

Can somebody please help.

Thanks

 

[Rod Gill]

Hi,

If all tasks and resources are based on the same calendar, then I think
float (slack in Project) will be the same for 5d and 7d calendars. If so
simply insert the Totals Slack or Free Slack column. otherwise, I don't
think a formula can calculate what you want.

If different tasks or resources do have different calendars then the only
way to calculate this is to:

Apply 7 day calendar
Copy Total Slack to Duration1 or text1
Re-apply 5 day calendar then compare Totals Slack with Duration1 or text1

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Stuck Contractor]

Trevor
Thanks for your help. It looks like this worked, but some of my dates
changed in the Late Start Column. This is an easy fix though.

Do you know if there is a way to round the numbers so there are no decimal
points?

Thanks

Assuming that an elapsed week is 7 days (that's a fact, actually, not an
assumption) and that a working week has 5 days, make a formula in a spare
Number field and multiply the [Total Slack] by 7/5.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au

I am working on a schedule and I need to show days of Float on a seven day
work calendar while keeping the working time on a five day calendar. The
only way I see to do this is to create a new formula. I am not sure how
these formulas are put together. I am pretty good in Excel, but am lost
at
this.

Can somebody please help.

Thanks

 

[Stuck Contractor]

Hi Rod,
Thanks for your Help. Trevor provided me information that worked to the
satisfaction of the owner I am working for.

Stuck Contractor

 

[Dytham]

Using backslash, rather than slash for division gives an integer result. eg:

([Total Slack]*(7/5))\480

Trevor
Thanks for your help. It looks like this worked, but some of my dates
changed in the Late Start Column. This is an easy fix though.

Do you know if there is a way to round the numbers so there are no decimal
points?

Thanks

Assuming that an elapsed week is 7 days (that's a fact, actually, not an
assumption) and that a working week has 5 days, make a formula in a spare
Number field and multiply the [Total Slack] by 7/5.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au

I am working on a schedule and I need to show days of Float on a seven day
work calendar while keeping the working time on a five day calendar. The
only way I see to do this is to create a new formula. I am not sure how
these formulas are put together. I am pretty good in Excel, but am lost
at
this.

Can somebody please help.

Thanks