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

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

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

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

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

Fred,

I am not calculating this on the paper. Sheeloo gave the formula which works
fine, but if the volume is in Lakhs and Hours are in thousands which i have
mentioned earlier... i am getting the head count as 0.66

Need your help!!!

Vicky



"Fred Smith" wrote:

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

.