I have a clock in/clock out app and I am trying to figure out how many days in a month employee worked. I used COUNT formula, but now I figured, if an employee clocks in twice or three times a day - my formula counts this as +1 working day.
Example: * 2021-5-21 - employee clocks in and out - this is 1 working day in my formula
* 2021-5-22 - same employee clocks in and out twice this day- my formula counts that as 2 working days. But it should be one working day.
This is how my formula looks now:
MASTER[Date Out 2],
([YEAR] = [_THISROW].[YEAR EMP]),
([MONTH] = [MONTH EMP]),
([Employee Name]=[Name].[Employee Name])
I thank you in advance for the help.