Need to know the hourly working employess count
they can log in different.
3 Answers
Lets try SUMPRODUCT() in this way.
=SUMPRODUCT((HOUR($C$3:$C$8)<=G3)*(HOUR($D$3:$D$8)>=G3))
=SUMPRODUCT((HOUR($AG:$AG)<=AJ2)*(HOUR($AH:$AH)>=AJ2))
I use this formula but showing #VALUE! error,Please check once.
If have data and time stamp then how can calculate the count of employees.
Image:- enter image description here
#Harun24hr
Related