You need to look at the logic of your question, For example 5 could return
either 10 or 15 and likewise 10.5 could return two values. On the assumption
you don't mean this try.

=IF(C6<=4,0,IF(C6<=5,10,IF(C6<=7,15,IF(C6<=10.5,10 ,15))))

"Basic DB Question" wrote:

What should the formula be for calculating the 1st break in my sheet,
based on the following shift lengths?
Hours
<4 =0 Minute
4-5 =10 Minutes
5-7 = 15 Minutes
7-10.5 = 10 Minutes
10.5= 15 Minutes
=if(c6<4,0....

Thanks in advance