【问】怎么将 202401222333 转化为 2024/01/22 23:33 ？

【答】利用下面的代码，可以转换为日期时间

    Dim myTime As String
    Dim myDate As Date
    myTime = "202401222333"
    myDate = CDate(Left(myTime, 4) & "-" & Mid(myTime, 5, 2) & "-" & Mid(myTime, 7, 2) & " " & Mid(myTime, 7, 2) & ":" & Right(myTime, 2))