=TEXT(TIME(0,0,(ROW(A1)-1)*10),"hh:mm:ss")&"-"&TEXT(TIME(0,0,ROW(A1)*10),"hh:mm:ss")
或
=TEXT(TIME(0,0,(ROW(A1)-1)*10),"[hh]:mm:ss")&"-"&TEXT(TIME(0,0,ROW(A1)*10),"[hh]:mm:ss")
下拉填充
夜的天空之歌:那按十分钟怎么弄呢?
=TEXT(TIME(0,(ROW(A1)-1)*10,0),"hh:mm:ss")&"-"&TEXT(TIME(0,ROW(A1)*10,0),"hh:mm:ss")
或
=TEXT(TIME(0,(ROW(A1)-1)*10,0),"[hh]:mm:ss")&"-"&TEXT(TIME(0,ROW(A1)*10,0),"[hh]:mm:ss")
温馨提示:答案为网友推荐,仅供参考