Try this in your J row cells
=IF(INT(LEFT(G1,2))<19,1,0)+IF(INT(MID(G1,4,2))<19,1,0)+IF(INT(MID(G1,7,2))<19,1)+IF(INT(MID(G1,10,2))<19,1,0)+IF(INT(RIGHT(G1,2))<19,1,0)&"/"&(5-(IF(INT(LEFT(G1,2))<19,1,0)+IF(INT(MID(G1,4,2))<19,1,0)+IF(INT(MID(G1,7,2))<19,1)+IF(INT(MID(G1,10,2))<19,1,0)+IF(INT(RIGHT(G1,2))<19,1,0)))
It is long sorry!
Bookmarks