如题所述
=IF(TEXT(A2,"hhmmss")>TEXT(B2,"hhmmss"),INT(B2-A2)*8+TEXT(E2-TEXT(A2,"hh:mm:ss"),"hh")+TEXT(TEXT(B2,"hh:mm:ss")-F2,"hh")&"小时",B2-A2)