Time Nested IF Formula

Highlighted
New Contributor

How can I limit scores of an event such as running by using nested if function in excel...Like 18 mins is 6 points and between 18 to 17:30 mins is 7 points and so on and so forth.....PS: Its only elapsed time.

5 Replies
Highlighted

@Seper825 , that's better to do with LOOKUP, like

image.png

and in attached file

Highlighted
Leme check and report back. Thnx buddy
Highlighted
Leme check and report back.. thnx
Highlighted

Thanks @Sergei Baklan ...it worked like a charm

Highlighted

@Seper825 , you are welcome