Calculating a percentage

[alan green (wheelhouse)]

I have two columns; one with Time Allocated and one with Time Taken - I
would then like to add another column that calculates the efficiency
percentage of a particular job.

E.g.
Time Allocated = 200mins
Time Taken = 400mins
Therefore the efficiency percentage would be 50%

Being a MAC user I have absolutely no idea how Excel works!

Any help would be much appreciated.

 

[Bob Greenblatt]

I have two columns; one with Time Allocated and one with Time Taken - I
would then like to add another column that calculates the efficiency
percentage of a particular job.

E.g.
Time Allocated = 200mins
Time Taken = 400mins
Therefore the efficiency percentage would be 50%

Being a MAC user I have absolutely no idea how Excel works!

Any help would be much appreciated.

Assume time allocated is in column A and time taken in column B. To
calculate the percentage simply divide column A by column B. an example
formula is =a1/b1. Fill this down for each row necessary. Make sure each
value added is an actual number. If you keyed in the values as 200mins, it
is text, not a value. Excel can not calculate with this. To have the cell
appear as you desire, enter the value as 200. Then apply a custom format to
the cell (see Help for a good explanation) of 0"Mins".

And "having absolutely no idea how excel works" is not unique to Mac users.

 

[PhilD]

Assume time allocated is in column A and time taken in column B. To
calculate the percentage simply divide column A by column B. an example
formula is =a1/b1. Fill this down for each row necessary. Make sure each
value added is an actual number. If you keyed in the values as 200mins, it
is text, not a value. Excel can not calculate with this. To have the cell
appear as you desire, enter the value as 200. Then apply a custom format to
the cell (see Help for a good explanation) of 0"Mins".

Adding to this, the column containing the formula needs to be formatted
as %. Otherwise 50% would appear as 0.5. If you don't want to fiddle
around with formats (though it's not difficult), change the formula to
=100*a1/b1.

PhilD