d2公式:
=if(a2="LONG",TEXT((NETWORKDAYS(F2,G2)-1)*8/24+(MAX(0,MIN(8/24,(G2-INT(G2)-9/24)))-(MIN(8/24,MAX(0,(F2-INT(F2)-9/24))))+(F2-G2+INT(G2)-INT(F2)>0)*8/24),"[h]:mm"),TEXT((NETWORKDAYS(F2,G2)-1)*9.5/24+(MAX(0,MIN(9.5/24,(G2-INT(G2)-8.5/24)))-(MIN(9.5/24,MAX(0,(F2-INT(F2)-8.5/24))))+(F2-G2+INT(G2)-INT(F2)>0)*9.5/24),"[h]:mm"))