Hi,
I'm creating a tracker for work and all I'm trying to do is simply count the amount of times (in column E of the 'tracker' tab) each agent has gone over their 'break' allowance (in the Data Dump tab) in the attached file using the formula =COUNTIFS('Data Dump'!E:E,">00:50:00",'Data Dump'!B:B,B2)
I cannot for the life of me figure out why it is not returning a result for any of them, I thought it might be something to do with the cell formatting but despite attempting different things nothing is returning a proper result and they are all just counting '0' despite this not being the case.
What am I doing wrong?
Bookmarks