How to show/convert days to weeks on project plan

Hello All,

duration column circled in blue is automated as per the project setting

circled in red is all manual

I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days

is there a formula I can use on another column to calculate the number of weeks and days to capture all this separately please? I need to calculate this for the target as well actual so i can measure the different in duration.

Any help would be appreciative

@Paul Newcome @Genevieve P. tagging you guys as always as you have been helpful to me in the past.

if anyone knows the answer please feel free to comment, i would really appreciate it.

I need this urgently please, thank you in advance!

Find more posts tagged with

Formulas

project plan

Accepted answers

All comments

bisaacs

Hey @Maz Uddin,

If you want the Actual Duration column in the Parent row to show the # of weeks, you could use this in that cell:

=INT(SUM(CHILDREN()) / 7) + "w"

Hope this helps!

Paul Newcome

Try something like this in the top row:

=INT([Actual Duration]@row / 5) + "w " + MOD([Actual Duration]@row, 5) + "d"

The Target would be the similar with the exception of changing both 5s to 7s. Since those are manually entered, they are not automatically accounting for working days like the project settings columns are.

MazU

@Paul Newcome

when i do this formula i get #INVALID OPERATION

Paul Newcome

Ok. Try this instead then:

=INT(NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row) / 5) + "w " + MOD(NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row), 5) + "d"

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.