時間+字符時間 (14158)

日期：

D2=B2+(IF(ISERR(FIND("小",C2)),"0:","")&SUBSTITUTE(SUBSTITUTE(C2,"分",),"小時",":"))

另解=B2+SUBSTITUTE(SUBSTITUTE(C2,"分",),"小時",":")/1440^(ISERR(FIND("小",C2)))



留言

張貼留言