C2=(RIGHT(LEFT(A2,FIND(" ",A2)-1),4)&"/"&LEFT(A2,LOOKUP(1,0/(MID(A2,{4,5,6},1)="/"),{3,4,5})))+LOOKUP(1,MID(A2,FIND(" ",A2)+1,{4,5})*1)+(RIGHT(A2,2)="PM")*0.5
另解=(MID(A2,FIND("/",A2,4)+1,4)&"/"&LEFT(A2,FIND("/",A2,4)-1))+MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2)-3)+(RIGHT(A2,2)="PM")/2
另解=(MID(A2,FIND("/",A2,4)+1,4)&"/"&REPLACE(LEFT(A2,LEN(A2)-3),FIND("/",A2,4),5,))+(RIGHT(A2,2)="PM")/2
留言
張貼留言