Wickidgemini
New Member
- Joined
- Jun 27, 2013
- Messages
- 7
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]
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]