|
如果你的830-330输入在C1，则在D1输入=TEXT(TEXT(LEFT((1200+RIGHT(C1,LEN(C1)-FIND("-",C1))&"00"),2)&":"&MID((1200+RIGHT(C1,LEN(C1)-FIND("-",C1))&"00"),3,2)&":"&RIGHT((1200+RIGHT(C1,LEN(C1)-FIND("-",C1))&"00"),2),"hh:mm:ss")-TEXT(LEFT(TEXT(LEFT(C1,FIND("-",C1)-1)*100,"000000"),2)&":"&MID(TEXT(LEFT(C1,FIND("-",C1)-1)*100,"000000"),3,2)&":"&RIG... |
