‘下面的单元格B2是秒数，将下面的公式粘贴到目标单元格，修改“B2”为秒数所在的单元格

=TEXT(INT(B2/3600),"00")&":"&TEXT(INT(MOD(B2,3600)/60),"00")&":"&TEXT(MOD(B2,60),"00")

 

效果如下

 

00:02:13	133
00:07:25	445
00:04:20	260
00:01:00	60
00:02:21	141
00:01:39	99
00:01:13	73
00:00:47	47
00:00:30	30