automate point system
 

I have seconds in column as reference ie: A1 = 00:00:06 -- I have to make
formula in which if a1<00:00:07 then cell =5 (round number) otherwise if cell
a100:00:07 but <00:00:14 then sum of cell =3 or if cell a100:00:14<00:00:25
then cell =2 or if cell a100:00:25 then cell =0 (tried several functions
but keep on getting error)