Forum Discussion
Excel Formula for Comparison
robywoo I would create a simple pivot table as in the attached file, summarizing the number of days for each number of hours (2, 3 or 6).
Riny_van_Eekelen Hi again Would this be the best way to filter for all employees who have done more full days than part days? Plus if the member has done 2 or 3 hours both are part days so would it be most efficient to change the number of hours to 6=F and any other number of hours as P, then do the pivot table then the conditional formatting and then filter the ones I want?
robywoo Personally, I would not replace the hours with F or P, but you could add a column for it. Then you will keep the hours, just in case you would ever want to sum hours per employee.
Perhaps the attached workbook does what you need.