201912061050时间差上下午 (6369)

D2:D8{=SUM(RIGHT(LARGE(IFERROR(LEFT(B2:C2,ROW($1:$5))*1,)+10^6*{1,2},{1,6}),6)*{1,-1})+SUM(FIND(RIGHT(B2:C2,2),"@上午下午")/2*{-1,1})*0.5+0.5

E2:E8{=MAX(IFERROR(LEFT(C2,ROW($1:$5))*1,))-MAX(IFERROR(LEFT(B2,ROW($1:$5))*1,))+SUM(FIND(RIGHT(B2:C2,2),"@上午下午")/2*{-1,1})*0.5+0.5

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite