Need to know the hourly working employess count

they can log in different.

CodePudding user response：

Lets try SUMPRODUCT() in this way.

=SUMPRODUCT((HOUR($C$3:$C$8)<=G3)*(HOUR($D$3:$D$8)>=G3))

CodePudding user response：

=SUMPRODUCT((HOUR($AG:$AG)<=AJ2)*(HOUR($AH:$AH)>=AJ2))

I use this formula but showing #VALUE! error,Please check once.

enter image description here

CodePudding user response：

If have data and time stamp then how can calculate the count of employees.

Image:- enter image description here

#Harun24hr