【问】怎么将 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))