‘下面的单元格B2是秒数,将下面的公式粘贴到目标单元格,修改“B2”为秒数所在的单元格
=TEXT(INT(B2/3600),"00")&":"&TEXT(INT(MOD(B2,3600)/60),"00")&":"&TEXT(MOD(B2,60),"00")=
‘下面的单元格B2是秒数,将下面的公式粘贴到目标单元格,修改“B2”为秒数所在的单元格
=TEXT(INT(B2/3600),"00")&":"&TEXT(INT(MOD(B2,3600)/60),"00")&":"&TEXT(MOD(B2,60),"00")=