Work Completion Percentage

[Wickidgemini]

Hello!!
I am struggling on how to get a percentage done for work completed. All my attempts are not giving me the percentage result I am needing and I know it can be done, I just can not find the correct formula. Here is what I am needing.
I need the percentage in the "Activity Complete %" in the box. So set hours to complete this is 281 hrs. So far only 140.5 hours have been worked. I need the percentage of that (50%) to show in the "Activity Completion" Box and as I get closer and closer to the set 281 hrs it gets lower and lower to end at 100% once the 281 is reached.
So far my percentages have been way off and then when I put in 281 as hours worked I get a #DIV/0! instead of 100%

This is probably a simple no brainer but its just not in my brain.
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Activity Name
[/TD]
[TD]Activity Complete %
[/TD]
[TD]Original hrs
[/TD]
[TD]Hrs Worked
[/TD]
[TD]Remaining Hrs

[/TD]
[/TR]
[TR]
[TD]Order Materials
[/TD]
[TD](Insert Percentage here)
[/TD]
[TD]281
[/TD]
[TD]140.5
[/TD]
[TD]140.5
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[DutchDiggy]

Hi, isn't there a problem with the . or comma's? Are you sure the hours are inserted as values? If I divide the Hrs Worked by Original Hours I get 100%?

 

[Wickidgemini]

Hi, isn't there a problem with the . or comma's? Are you sure the hours are inserted as values? If I divide the Hrs Worked by Original Hours I get 100%?

Well there ya go I knew it was going to be a no brainer. Prime example of a OE (Operator ERROR)
I was dividing Original Hours by Hours Remaining........... *Sigh*
Thank You for the help!!!!

 

[DutchDiggy]

* ROFL *


Great that my own small mind could be of your assistance!