1. Cell L3 的formula

=IF(LEN(D3)=1,"-",
IF(LEN(D3)=3,LEFT(D3)&":"&RIGHT(D3,2)))
            




2. Cell M3 的formula

=IF(LEN(E3)=1,"-",
IF(LEN(E3)=3,LEFT(E3)&":"&RIGHT(E3,2),
IF(LEN(E3)=4,LEFT(E3,2)&":"&RIGHT(E3,2))))
            




3. Cell N3 的formula

=IF(AND(L3="-",M3="-"),
"-",

IF(AND(
OR(C3="週六",C3="週日"),
M3>TIME(12,0,0)),
TEXT(TIME(12,0,0)-L3+M3-TIME(13,0,0),"H")&"H",

IF(AND(
OR(C3="週六",C3="週日"),
M3<=TIME(12,0,0)),
TEXT(M3-L3,"H")&"H",

IFERROR(
IF(M3-TIME(17,0,0)>=TIME(18,0,0)-TIME(17,0,0),
TEXT(M3-TIME(17,0,0),"H")&"H",
"-"),"-"))))
              
            

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---