Calculate number/percentage less than x amount based on text in another column

Hi there

I'd like to lookup all cells than match the term 'blue' in column A and calculate what percentage fall below a certain figure (in this example 15 minutes). I would then like to do the same for all other cells in column A exclude 'blue'.

The sheet attached should explain what I am looking to do.

Thanks in advance

I couldn't get the COUNTIFS function calculate percentages.

What I mean by 15 minutes, is that I wanted the calculation to find all Blue times and calculate how many of the Blue times were below 15 minutes. In the example sheet it would 100% because all of the times next to the Blues are below 15 minutes. But for the others (i.e. not Blue) 3 are over 15 minutes so the percentage would be 57% (i.e. 57% were below 15 minutes, 43% over).

I don't know how to do a COUNTIFS for all options except Blue.

First formula worked for me in my real sheet but second didn't. It's ok though as I've done it manually using your first formula. It was the minutes that was incorrect.

Thanks for your help. Much appreciated.