IFS formula with TIME

[Jewells0905]

I am having issues getting this to generate, I was getting an error, but am now getting a NAME error. I am trying to generate labels (A,B,C,D) for a group of racers based on their completion time. There are four groups A, B, C, and D with times <=1:45:00, <= 2:00:00, <= 2:15:00, and > 2:15:00, respectively. The formula I am currently using is below. =IFS(C2TIME(1, 45, 0), "A", C2TIME(2, 0, 0), "B", C2TIME(2, 15, 0), "C", "TRUE", C2TIME(2, 15, 0), "D") the racers times are in column C. Any help is appreciated, please let me know if you need more info. I tried to upload a mini sheet and a photo but for some reason, it won't allow me to. Below is a snip of what I am attempting to solve

First Name	Last Name	Time	Time behind winner	Group	Winning time	Average time	Slowest time
George	Adams	2:16:47	0:46:44	#NAME?	1:30:04	1:59:37	2:29:04
Lucia	Adams	1:51:52	0:21:48		1:30:04	1:59:37	2:29:04
Byron	Alexander	2:20:00	0:49:57
Audrey	Alexander	1:48:50	0:18:46
Olivia	Armstrong	2:16:12	0:46:09
Cadie	Armstrong	1:39:48	0:09:44
Byron	Bailey	2:03:36	0:33:33
Walter	Baker	2:19:22	0:49:18
Lydia	Baker	1:39:42	0:09:39

 

[adunn_23]

In the 2nd one remove the ( from before the 2nd & 3rd C4 & add a true part ate the end like the formula you posted.

Can you actually write out the full formula I’m stuck on the same question thank you

 

[adunn_23]

You are amazing! That worked! I've been trying to get this figured out for about 6 hours! Thank you so much!

What do you mean by remove the 2nd and 3rd C4.can you write the formula out thank you

 

[Fluff]

Hi & welcome to MrExcel.
As I said before, I don't use the IFS function as it is less efficient than using nested IF functions.

 

[adunn_23]

Hi & welcome to MrExcel.
As I said before, I don't use the IFS function as it is less efficient than using nested IF functions.

Yes I’m aware of that. I just need more context on what you meant by the 2nd one remove the ( from before the 2nd & 3rd C4 & add a true part ate the end like the formula you posted.please and thank you