Please help me with this formula. Not sure how should it be calculated. Thanks

[Aleng]

If there is 20 employees, and all 20 needs to works = saturdays but only 6 employess out of 20 are required so only 6 will be working.

So if 6 employess work every saturday ...how many saturdays will each one work in a month.

Thanks for helping
Aleng

 

[Weaver]

I figure there's a 6/20 (30%) chance anyone will have to work a given saturday.

There's 52 in a year, or 52/12 = 4 1/3 per month. 30% of which is 1.3

so the formula would be

=6/20 * 52/12

..I think...

 

[mortgageman]

If there is 20 employees, and all 20 needs to works = saturdays but only 6 employess out of 20 are required so only 6 will be working.

So if 6 employess work every saturday ...how many saturdays will each one work in a month.

Thanks for helping
Aleng

This is more of a middle school question and not a Excel question, but hey - maybe you are a Dad helping out his son! Anyway, since you said a month, without hindsight, the questions needs you to assume how many saturday's there are in the month - it could be 4 or 5. Lets assume 4. Then 20/6 = 3 remainder 2. Therefore, 18 of the 20 will work 1 Saturday and two get saved for the next month.

Gene Klein

 

[Aleng]

Thanks for helping!

about dad helpin daughter...nanana

njoy weekend!

 

[Aleng]

I figure there's a 6/20 (30%) chance anyone will have to work a given saturday.

There's 52 in a year, or 52/12 = 4 1/3 per month. 30% of which is 1.3

so the formula would be

=6/20 * 52/12

..I think...

So each emp will work at least 1 saturday in a month....

 

[mortgageman]

So each emp will work at least 1 saturday in a month....

No - did you read my answer?

Gene Klein