Excel中日期时间格式和计时单位的转换

A1=20090601182317A2=98

=TEXT(LEFT(A1,8),0000-00-00)& &REPLACE(REPLACE(RIGHT(A1,6),3,,:),6,,:)

=TIME(0,0,A2)