Skip to content
ProjectControls.com
Asta Powerproject

duration decimal

In the Open Standard
Chris WilliamMember for 13 years 8 months
Created
6
3
0

Dear Mike/All ,

 

     How to make duration in round figure? I have duration column in days. In which few duration  are showing  as 1d 30min and 2d 2h. I need to change these durations in round figure as 1d and 2d in the whole column. How to do that? Any tip?

 

Regards,

Chris       

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi ChrisClick on the column

    Hi Chris

    Click on the column head > chose Format Cells > Duration > you now have a variety of options.

    I prefer 0 decimal point + percent format.

    Best regards

    Mike Testro

    Report
  2. 0
    Chris William ·
    #2

    Thanks Mike

    Thanks Mike

    Report
  3. 0
    Marc winslett ·
    #3

    Good Afternoon, I was

    Good Afternoon, I was looking for a solution to a similar 'wish'. I want to show progress in days ONLY but I thought I'd exhausted all options to no avail. I recently saw a paper copy of a Powerproject programme, which had exactly what I wanted - durations shown in days only! I couldn't find who had produced this, but am sure that someone out there knows the (probably quite obvious) setting I need to change. Any clues appreciated! Marc.
    Report
  4. 0
    Mike Testro ·
    #4

    Hi MarcFollow the

    Hi Marc

    Follow the instructions I gave to Chris - Right Click on the column head > chose Format Cells > Duration > you now have a variety of options.

    Select "Days" on the drop down > 0 for decimal places and Percent for the format.

    Best regards

    Mike Testro

    Report
  5. 0
    Marc winslett ·
    #5

    Mike, Thanks for the

    Mike, Thanks for the response - I'm still having a problem with that, as I don't have an option to select 'percent' from the 'duration format' drop down. It only gives me the following options: Compact (4:2) Decimal (4.00d, 4.40w) Decimal (4d, 4.4w) Mixed time units (4w 2d) Therefore I'm still confused! Regards, Marc.
    Report
  6. 0
    Mike Testro ·
    #6

    Hi MarcUse decimalBest

    Hi Marc

    Use decimal

    Best regards

    Mike Testro

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?