Hi,
I am new here. Please be patient.
I wanted to count the number of instances that Matt's been late.
If there are consecutive timestamps (ex. 600-620, 620-640) that he's been late, I wanted Excel to display 1 and then I'll just sum it up. Or if Excel can do this directly, add all the instances because what I actually need is the total per person.
In this example, I would need a result of 4 instances.
Also, please tell if the blank cells will affect the formula or if I still need to do something about them.
Thank you very much.
excel.jpg
Bookmarks