durations (days) showing up as decimals

Posted on 2005-05-15
Last Modified: 2013-11-15
i'm creating a template from an old project file. when i created the template, it prompted me to delete all of the old information it contained. so, everything cleared out (costs, tracking dates, resources, etc.), but the durations in the entry view showed up as decimals (i.e. 21.9 days). is there a way to force project to show the duration as a whole or non-decimal number? thanks.
Question by:miguel0666
    1 Comment
    LVL 17

    Accepted Solution

    Don't think there is ... if the duration is an exact number of days it doesn't show the decimals.  But if the duration is 2.9 or 2.95  days, that's what it shows.

    You could add a text field to show the rounded days if you want: use the formula:

    Format([Duration]/480,"0") & " day" & IIf([Duration]/480>1.5,"s","")

    (this assumes 480 working minutes per day , ie 8 hours. Amend if your calendar is different)

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
    Article by: x-men
    Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now