Is there a technique to shorten formulas such as this one?

=IF(K7=TIME(0,1,30)),J7,IF(AND(K7TIME(0,1,45),K7< =TIME(0,2,10)),J7+2,IF(AND(K7TIME(0,2,10),K7<=TIM E(0,2,30)),J7+4,IF(AND(K7TIME(0,2,30),K7<=TIME(0, 2,40)),J7+6,IF(K7TIME(0,2,40),J7+10))))))


I'm always creating these spaghetti style formulas and I'd like to
learn some techniques to shorten them.

Any advice or recommendations would be greatly appreciated!


--
dwest100
------------------------------------------------------------------------
dwest100's Profile: http://www.excelforum.com/member.php...o&userid=18864
View this thread: http://www.excelforum.com/showthread...hreadid=471673