Hi, I'd a question that bothered me a few weeks. My worksheet is like this:
Column A: Names of employees
Column B: Duty hours of that particular shift
What I want to achieve is: count the number of person, without duplicate, that worked duty shifts for less than 24 hours.
E.g. Michela worked 12 hrs, 8 hrs and 8.5 hour shifts, although all of the shifts are less 24 hours, but I just want to count them as 1 person, and extending to the column of data.
I'd also uploaded a sample of the sheet, which it showed "3 different person worked duty shifts less than 24 hours". Hope it helps in understanding.
Thank you for your help in advance!!
Cheers
Bookmarks