Hi,

I have been using this formula in my spreadsheet.

=IF(OR(ISTEXT(I5),ISTEXT(J5)),0,((MOD(J5-I5,1)-LOOKUP(MOD(J5-I5,1),{0;0.197916666666666;0.28125},{0;0;0}))*24))

It takes the start time in I and finish time in J.....

What I require is for a shift which is 6.5 hours long or less to not deduct any break, however when I create a shift with which is 6.5 hours in length, it deducts 15mins.

Please help!

J.