Excel 将秒转换成时分秒（将视频时长秒转为时分秒），java将秒转为时分秒

一、四舍五入

=TEXT(C2/86400,"HH:MM:ss")

=TEXT(C2/86400,"d天h小时m分钟s秒")

=TEXT(C2/86400,"h小时m分钟s秒")

备注：

1.将C2改为对应的单元格即可

二、舍弃小数

=TEXT(TRUNC(C2)/86400,"HH:MM:ss")

=TEXT(TRUNC(C2)/86400,"d天h小时m分钟s秒")

=TEXT(TRUNC(C2)/86400,"h小时m分钟s秒")

备注：

1.TRUNC(C2)，忽略小数

2.将C2改为对应的单元格即可

图例：

废话不多说，上代码

package util;


public class SecToTimeUtil {

    public static String secToTime(int time) {
        String timeStr = "00:00:00";
        int hour = 0;
        int minute = 0;
        int second = 0;
        if (time <= 0) {
            return timeStr;
        } else {
            minute = time / 60;
            if (minute < 60) {
                second = time % 60;
                timeStr = "00:" + unitFormat(minute) + ":" + unitFormat(second);
            } else {
                hour = minute / 60;
                minute = minute % 60;
                second = time - hour * 3600 - minute * 60;
                timeStr = unitFormat(hour) + ":" + unitFormat(minute) + ":" + unitFormat(second);
            }
        }
        //System.out.println(timeStr);
        return timeStr;
    }

    private static String unitFormat(int i) {
        String retStr = null;
        if (i >= 0 && i < 10) {
            retStr = "0" + i;
        } else {
            retStr = "" + i;
        }
        return retStr;
    }

    public static void main(String[] args) {
        secToTime(2051);
        secToTime(1051);
        secToTime(5051);
    }
}

结束！