Forum Discussion
Excel Formula
The problem I am trying to solve is... Over a single day i have two data columns, one is a staff start time and the other is staff end time. What I want to do is ascertain how many staff are pres...
Hi Peter,
For data structured like this
the formula could be
=SUMPRODUCT(($C$3:$C$6<=F3)*($D$3:$D$6>=(F3+1/24/4)))