I cracked it by using 1 Helper cell.... I was trying it for 2 days and was struggling to crack it. But I remembered to take help from this site as I did it once.
Well, I just two test helper cell to evaluate the conditions of "Active Time". Then I incorporated those conditions in Countifs.
As you suggested I evaluated TRUES and FASLSES suggestion and cracked it
Bravo!!!
That is music to our ears.
Your judicious use of helper columns is to be applauded as well as a clear understanding that dates and times are numbers.
Having said that an offer of "better solution" I don't have.
I can only offer further encouragement to explore alternatives to COUNTIFS. I offer the below. We often see SUMPRODUCT as one of those alternatives.
See if this is of help.
Once again, good work.
Bookmarks