Using Hours and Minutes as argument for IF function

[Miskondukt]

Hey guys,

So, I have both a start and end time that will produce a calc of total time taken. What I want to do is create the following if function (or a like-working one) to produce a 'score' based on duration.

What I first wrote,

=IF(m6<=4,40,IF(m6>=5:00<=5:59,30,IF(m6>=6:00<=6:59,20,IF(m6>=7:00,10,""))))

The function gives me an error, but if I remove the ":00" from the numbers it'll work but not produce the correct answer. For instance, when attempted in a cell with the duration of 16:29 (over 7) it still popped out "0" for the score. It needs to be able to read minutes/hours.

Suggestions?
Thank you.

[ConneXionLost]

Something like this?

Please Login or Register  to view this content.

[Miskondukt]

That did it, thank you Connie. I will mark answered.