question

KishRanai-2750 avatar image
0 Votes"
KishRanai-2750 asked emizhang-msft commented

Rounding of partial percentage of a workday

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-itpro
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KishRanai-2750,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·

Hi
I thought this item is closed during our last discussion where u said I have posted this query in the wrong forum. My query is on MS project and since then I have posted this same query in the MS project forum and have got my answer and the item is closed as well.
Thanks for asking.
best Rgds
Kish

0 Votes 0 ·

OK ~ :)

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @KishRanai-2750,
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.




328.png (29.4 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

What u have given above is to solve if I am using MS Excel. The issue I described is on MS Project Pro 2010. There is no option right click to format the cell.

Best Rgds
Kish

0 Votes 0 ·

Hi, if your problem is related to Project, you should post this issue to Project forum: https://techcommunity.microsoft.com/t5/project/ct-p/Project The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


0 Votes 0 ·

Hi

My humble and sincere apologies. I thought I was posting in the MS Project forum. I will re-post above query based on the link you gave.

Sorry for the inconvenienced caused.

Best Rgds
Kish

0 Votes 0 ·
Show more comments