Help! I am having trouble with the below formula returning a #value error. I know nested formulas do this sometimes and I need to figure out how to fix this one. What I am doing is calculating clock times, and for some, I need to subtract one hour if they work more than 12 hours and a half hour when they work less than 12.

IF(AND(O2="yes",AF2=1,ROUND(MOD(L2-K2,1)*24,2)>12),ROUND(MOD(L2-K2,1)*24,2)-1),IF(AND(O2="yes",AF2=1,ROUND(MOD(L2-K2,1)*24,2)<12),ROUND(MOD(L2-K2,1)*24,2)-0.5,ROUND(MOD(L2-K2,1)*24,2))

Any help or suggestions is greatly appreciated!