求助该公式要怎么修改才行

wjj198904

=IF((--LEFT(TEXT(H97-G97,"[h]:m"),FIND(":",TEXT(H97-G97,"[h]:m"))-1)-(DAYS360(G97,H97)-NETWORKDAYS(G97,H97)+1)*24)<0,ROUNDUP(((--LEFT(TEXT(H97-G97,"[h]:m"),FIND(":",TEXT(H97-G97,"[h]:m"))-1)-(DAYS360(G97,H97)-NETWORKDAYS(G97,H97)+1)*24)+24)/24*8,0)&":"&MID(TEXT(H97-G97,"[h]:m"),FIND(":",TEXT(H97-G97,"[h]:m"))+1,100),ROUNDUP((--LEFT(TEXT(H97-G97,"[h]:m"),FIND(":",TEXT(H97-G97,"[h]:m"))-1)-(DAYS360(G97,H97)-NETWORKDAYS(G97,H97)+1)*24)/24*8,0)&":"&MID(TEXT(H97-G97,"[h]:m"),FIND(":",TEXT(H97-G97,"[h]:m"))+1,100))




该公式在1月30日到1月31日的时候    时间的差就不会除以24乘以8了  其他情况都正常，
求帮忙修改成月天数为31天的时候也能用该公式

wjj198904

只要是月份为31天都不能用上面个公式

wjj198904

求帮助     

wjj198904

  请求帮助