Project Report: Display Project Actual Duration without "Days" | Community
Skip to main content
M
mvsteep
Level 2
October 1, 2024
Solved

Project Report: Display Project Actual Duration without "Days"

  • October 1, 2024
  • 2 replies
  • 989 views

Could someone share the text mode needed to display the Project Actual Duration without "Days" in the result? This will save us a step in excel so we don't need to delete all the "days" in this column.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Hi @mvsteep 

 

use valueexpression and do the calculation manually: get the minutes, divide by 60 (hours), then 8 (days) and round to 2 decimals.

 

valueexpression=round({actualDurationMinutes}/60/8,2) linkedname=direct valueformat=string displayname=Actual Duration (no days) namekey=actualduration textmode=true querysort=actualDurationMinutes viewalias=actualduration

 

2 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
October 1, 2024

Not able to test this out at the moment but try messing with the value format in text mode of that column. Instead of HTML maybe numberasstring, can’t remember what it would be. Find the value format of another column that is number only and use that for context and see if that works.

If can’t get it, in your excel you can easily do a bulk find & replace to replace “Days” with “ “ (a space).

If this helped you, please mark correct to help others : )
M
mvsteepAuthor
Level 2
October 1, 2024

didn't work, looks like the system keeps reverting back the value format to it's original form, "compound#M:D":

 

displayname=Actual Duration (no days)
linkedname=direct
namekey=actualduration
querysort=actualDurationMinutes
textmode=true
valuefield=actualDurationMinutes
valueformat=compound#M:D
viewalias=actualduration

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
October 3, 2024

Hi @mvsteep 

 

use valueexpression and do the calculation manually: get the minutes, divide by 60 (hours), then 8 (days) and round to 2 decimals.

 

valueexpression=round({actualDurationMinutes}/60/8,2) linkedname=direct valueformat=string displayname=Actual Duration (no days) namekey=actualduration textmode=true querysort=actualDurationMinutes viewalias=actualduration

 

M
mvsteepAuthor
Level 2
October 3, 2024

ah, thank you!

Terms & ConditionsAccessibility statement

Loading footer...