Good morning.

I'm having trouble using time (minutes and seconds) in an IF formula. I'm
trying to assign a rating to four time thresholds. My rating and thresholds
are as follows...
"EE" <0:45 sec
"MA" 0:45-1:00
"MM" 1:01-1:30
"DNM" 1:31
For example, if cell P7 is 0:42 then cell Q7 would be assigned a rating of
"EE". If P7 is 1:31 then "DNM". Please tell me what my IF formula should be.
I have tried everything and nothing has worked so far. I appreciate your
help. Thanks!