1 2 3 4 5 6 7 8 9 10 11 12
| Sub tast()
d = "050316 8H"
Debug.Print CDate(Replace(Format(d, "@@/@@/@@ @") & IIf(Right(d, 1) = "H", "00", ""), "H", ":"))
d = "050316 8H3"
Debug.Print CDate(Replace(Format(d, "@@/@@/@@ @") & IIf(Right(d, 1) = "H", "00", ""), "H", ":"))
d = "050316 8H30"
Debug.Print CDate(Replace(Format(d, "@@/@@/@@ @") & IIf(Right(d, 1) = "H", "00", ""), "H", ":"))
d = "05031623H"
Debug.Print CDate(Replace(Format(d, "@@/@@/@@ @") & IIf(Right(d, 1) = "H", "00", ""), "H", ":"))
d = "05031623H55"
Debug.Print CDate(Replace(Format(d, "@@/@@/@@ @") & IIf(Right(d, 1) = "H", "00", ""), "H", ":"))
End Sub |
Partager