Forum Discussion
Solved
I want to track individual times, but there can be multiply times in one cell
I've tried three different formulas but none of them are giving me the data I want. It seems with '=SUM' formula, it's also counting 16:00 when I only want 6:00, I don't even know what the '=COUNTA' ...
Do you want to count how many times the time 6:00 occurs?
=SUM(--ISNUMBER(SEARCH(", 6:00, ", ", "&C10:C15&", ")))
or using your first formula
=LET(d, ", "&C10:C15&", ", t, ", 6:00, ", SUM(LEN(d)-LEN(SUBSTITUTE(d, t, "")))/LEN(t))
Do you want to count how many times the time 6:00 occurs?
=SUM(--ISNUMBER(SEARCH(", 6:00, ", ", "&C10:C15&", ")))
or using your first formula
=LET(d, ", "&C10:C15&", ", t, ", 6:00, ", SUM(LEN(d)-LEN(SUBSTITUTE(d, t, "")))/LEN(t))