Greetings
I am using this formula SUM(LEN(D21:D609)-LEN(SUBSTITUTE(D21:D609,"T","")))/LEN("T") as an array formula to count tears "T" recorded also using the same formula to count other quality faults such as bures "B"
I now wish to record the time taken to repair the tear or bure in column D21:D609 by entering T14B15 effectively the tear took 14 minutes to repair and the Bure took 15 minutes to repair what must I do to count total tears and sum the total minutes to repair the tear or the Bure?
Can you assist please