Percentage of complete

T

Toni

I need the formula to use for finding the percentage of work completed. I
need to divide ([Installed Direct Hrs Earned]/[Est Man Hrs])*100 in this
calculation I get the percentage answer of 41000.00% using
SumOfEst Man Hrs SumOfInstalled Direct Hrs Earned
926.34 95.33
The answer in Excel is 10.29% What am I doing incorrect? 95.33/926.34

Thanks in advance
 
M

Maarkr

format(95/926,"percent") = 10.26%
be sure to reference the full name of the query field, ie, [sumofest man
hrs], not just the [est man hrs] field or you'll get just the last record
detail.
 
J

Jerry Whittle

That is strange. If you are doing this with a query, show us the SQL. Open
the query in design view. Next go to View, SQL View and copy and past it here.
 
Top