My title may not exactly say what I need, but,
Not sure how to approach this so am looking for suggestions.
I have multiple years of payroll data. Within each payroll transaction record is "hours worked for this pay period."
There are typically 26 pays per year.
I need to determine via Excel all those who, during any 12 contiguous months, worked at least 1,000 hours.
How would you approach this?
Not sure how to approach this so am looking for suggestions.
I have multiple years of payroll data. Within each payroll transaction record is "hours worked for this pay period."
There are typically 26 pays per year.
I need to determine via Excel all those who, during any 12 contiguous months, worked at least 1,000 hours.
How would you approach this?