在E2中输入或复制粘贴下列公式
=D2&TEXT(A2,"e/m/d")&" "&TEXT(B2,"h:ss")&"-"&TEXT(C2,"h:ss")
下拉填充
=D2&TEXT(A2,"e/m/d ")&TEXT(B2,"h:mm")&"-"&TEXT(C2,"h:mm")
=D2&A2&" "&B2&"-"&C2