Time sheet formula?

  • Thread starter Thread starter Basic DB Question
  • Start date Start date
B

Basic DB Question

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
Click to expand...
=if(c6<4,0....

Thanks in advance
 
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))))
 
Are these values cumulative? If so, one way:

=LOOKUP(C6,{0,0;4,10;5,25;7,35;10.5,50})
 
Back
Top