Help with a formula using values that are minutes and seconds

[cbenner3017]

Hello all, I can't get the formula below to work:
=IFS(F21<5," AN AMAZING",F21<6," AN EXCELLENT",F21<7,"A GOOD",F21<10,"A NOT GOOD",F21>=10,"A REALLY NOT GOOD")

The value of F21 is 7:17

The answer that I am getting is: "A REALLY NOT GOOD" when it should be "A NOT GOOD" based on the formula.

Can someone please help?
Thank you!

[Pete_UK]

You should be aware that time values in Excel are stored as fractions of a 24-hour day, so that 12:00:00 is represented internally as the value 0.5, and 6:00:00 as 0.25. If your value of 7:17 is meant to represent minutes and seconds, then it will actually be a much smaller fractional value.

I suspect, however, that the value 7:17 has actually been stored as a text value that just happens to look like it could be in minutes and seconds.

Hope this helps.

Pete

[modytrane]

Instead of comparing F21 with a number, you can try replacing all F21 with Hour(F21).
Also, you need nested IFs. The =IFS is not a valid function.
Here's what the formula you can use. It should work.

[cbenner3017]

this thread is solved now

[FDibbins]

cbenner, you can mark your threads solved by clicking on the THREAD TOOLS towards the top of the screen - I will do this 1 for you.