Hi Claus,

I have seen the formula in one-story & applied the same to my data, but the problem is it counts blank cells also.

For example if total working days in a month is 22 & if an employee left the org. in middle of the month say 20 days he worked.

While counting whether he completed 9 hours it's showing 22. It is calculating blank also.