Billability Percentage

[dcfrom79]

Hi all,

New to the site, looks like a great resource. I need some help - it has been covered in a certain way in here, but I can't work out how to change the formula for it to give me the desired result.

My company works from a rate card and I am currently trying to work out if this rate card is correct or losing us money. So, I am looking at

Column A:
Billable/Rate Card Hours

and then

Column B:
Actual Hours Taken.

I want a third column which will calculate the percentage difference and tell me what percentage we are off in billed v's actual hours.

I'd be really grateful if anyone can help. Not only can I not do formulas, but I can't do maths either, so your advice would be gratefully accepted and very much needed!

Cheers

Dan

 

[Gerald Higgins]

If Billed hours (let's say 50) are in A2, and Actual hours (let's say 60) are in B2, then this formula will show actual as a fraction of billed
=B2/A2
which in this case will be 1.2.
You could also choose to format this as a percentage, so it will appear as 120%.

You might only want to analyse the difference, in which case you could use
=(B2-A2)/A2
which will give you 0.2.

 

[dcfrom79]

Cool, that's great, thanks Gerald! And easier than I thought!