Rounding of partial percentage of a workday

Kish Ranai 1 Reputation point
2021-03-04T12:13:30.62+00:00

Hi
I observer something strange happening to my project plan maybe somebody can help explain what is happening: I have task called "Status Report" which is allocated 1hr to do this task.

This is allocated to James Bond whose hourly rate is $50 and his normal working period per day 8hr. Hence, 12.5% is basically 1hr (0.125 x 8=1).
So I assign to task "Status Report" 12.5% and assign it to James Bond. This is what I am observing:

1. when I type 12.5% MS Project displays it as 13% and calculates the cost as 0.125 X $50=$6,25 - fine all well and good

2. now when I change the allocation to say 10% MS Project displays it as 10% and calculates the cost as 0.1 x $50 = $5 - all correct no issue as well

3. then when I revert back to 12.5% MS displays it as 13% BUT now calculates the cost as 0.13 x $50 = $6.50 - here it starts show inconsistency

Why when I switch back to 12.5% in (3) it actually uses 13% x %50 = $6.50 which is not what I want this slightly more than 1hr's cost,

I tried doing various changes etc I cannot get to the status back as shown in (1) above.

Why is this so?

Can someone let me know how I can fix the cost calculation as 0.125 x $50 and NOT as 0.13 x $50

Help much appreciated.

Best Rgds

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,238 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 27,081 Reputation points Microsoft Vendor
    2021-03-05T03:27:38.997+00:00

    Hi @Kish Ranai ,
    Right click the cell- select Format cells...- select Percentage and Decilmal places: 0:

    74614-328.png

    If my understanding is incorrect, please provide more information and I'm glad to help you.
    Any updates please let me know and I'm glad to help you.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.