Counting how minutes staff are late.

[paulrm906]

Hello everyone

I am currently using the below formula that counts the number to the right of the letter "L" but if the staff member is late more then 99 minutes then the formula will not work (will not work when there are more then 2 digits to count). I have tried various alternatives but so far no luck.

{=SUM(IF(ISNUMBER(FIND($L$2,O6:GN6)),VALUE(RIGHT(O6:GN6,FIND($L$2,O6:GN6)+1)),0))}

Plus the above formula is an array formula.

Any help or suggestions will be greatly appreciated.

Paul

 

[Lewiy]

Try this:

{=SUM(IF(ISNUMBER(FIND($L$2,O6:GN6)),VALUE(SUBSTITUTE(O6:GN6,L2,""))))}

 

[paulrm906]

Thanks Lewiy

That works great.

Paul