B2的内容(9:30-15:30), 这个公式得出的数是6, 红色字体意思是明白的,整个公式怎么理解
IF(ISERR(IF((RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1))<0,INT((1+(RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1)))*24/0.25)*0.25,INT(((RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1)))*24/0.25)*0.25)-0.5),0,IF((RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1))<0,INT((1+(RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1)))*24/0.25)*0.25,INT(((RIGHT(B2,LEN(B2)-FIND("-",B2)))-(LEFT(B2,FIND("-",B2)-1)))*24/0.25)*0.25)-0.5)
|