The duration of SF in GC is an essential aspect for understanding their formation. Contrary to previous presumptions that all stars above 8 $M_ explode as CCSN recent evidence suggests a more complex scenario. We analyse iron spread observations from 55 GC to estimate the number of CCSN explosions before SF termination, thereby determining the SF duration. This work for the first time takes the possibility of failed CCSN into account, when estimating the SF duration. Two scenarios are considered: one where all stars explode as CCSN and another where only stars below 20 $M_ lead to CCSN as most CCSN models predict that no failed CCSN happen below 20 $M_ odot$. This establishes a lower ($ Myr$) and an upper ($ Myr$) limit for the duration of SF . Extending the findings of our previous paper, this study indicates a significant difference in SF duration based on CCSN outcomes, with failed CCSN extending SF by up to a factor of three. Additionally, a new code is introduced to compute the SF duration for a given CCSN model. The extended SF has important implications on GC formation, including enhanced pollution from stellar winds and increased binary star encounters. These results underscore the need for a refined understanding of CCSN in estimating SF durations and the formation of multiple stellar populations in GC