假设A2单元格的数据为：38分25秒，则可在B2单元格输入公式：=TEXT("00:"&SUBSTITUTE(SUBSTITUTE(A2,"分",":"),"秒",""),"hh:mm:ss")即可实现你的要求
