标签：时分秒

2021-11-01tian阅读(345)赞(0)

=TEXT(A1/24/60/60,”HH:MM:SS”) =TEXT(A1/3600/24,”[H]:mm:ss”)