FIND THE INEFFICIECNT STAFF FOR LAST 6 MONTHS

Question

I have the following dataset

It contains the hrs every staff has worked in each month.. Now my requirement is to segregate these people based on the hrs they worked over last 6 months.

I mean the people who worked for 00:00 to 10:00 hrs (low hrs) for the whole six months should be shown together, people who worked for 00:00 to 10:00 hrs for any 5 months should be shown together, people who worked for 00:00 to 10:00 hrs for any 4 months should be shown together and so on.

Attached the dataset for reference.

crew redundancy (25 apr).csv

Qiu · Answer

@ajaymanshani 
Thank you for the informaion.
Maybe this one helps?

0425-ajaymanshani.yxmd

ajaymanshani · Answer

Hey, By any five months what I mean is the staff who have low working hrs in 5 months out of 6 present in the dataset.

For example

AJAY

NOV - 00:00 DEC - 05:00 JAN - 06:00 FEB - 11:00 MAR - 00:00 APR - 00:00

So above this staff has low working hrs (00:00 to 10:00) for 5 months (except FEB)

Qiu · Answer

@ajaymanshani 
By any 5 months, you mean adding up the 5 months with least working hours?

or we have calculate each combinations of months?