Vicky. Tell us how you would calculate it on paper. Then we can help you
with Excel. It all depends on your definition of "head count".

Regards,
Fred.

"Vicky" wrote in message
...
Sheeloo, Can you help me on this.... when the volume is given in lakhs and
hours in thousands i am getting the head count very less... any idea?

Thanks!!!
Vicky

"Vicky" wrote:

I am getting the answer 0.66, what to do??

Vicky


"Sheeloo" wrote:

How would you calculate it on paper?

I guess headcount would be Volume/(Set Targets X Hours Worked)

Assuming you have Volume in cell B2, Set Targets in C2, Hours Worked in
D2
and you need the headcount in E2 then enter this formula in E2
=B2/(C2 * D2)

You can copy the formula down Col E if you have data in many rows.

If your formula is different then you can combine B2, C2 and D2 with
+, - ,
* (for multiplication) and / (for division) as per your need.
"Vicky" wrote:

I need a formula which calc the required Head count

Task Volume Set Targets Hours worked Head Count
ABC 196500 85 3500 ?????

Thanks in Advance!!!!!
Vicky