Forum Discussion
javoseabaugh
Jan 05, 2024Copper Contributor
Count if between range of times
I have a spreadsheet with two sets of data. One has Overtime with start and end time and on the other tab I have a table to 30 minute intervals and I am trying for excel to tell me how many people I ...
ecovonrein
Jan 14, 2024Iron Contributor
There is no set of people in your OP. Impossible to answer. Probable answer: Loop thru people with BYROW, FILTERing the other tables to figure out what OT they are doing.