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

Excel 中将时长秒转为时分秒

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

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

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

舍弃小数

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

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

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

JAVA实现

package util;

/**

• @author 我是有多懒

• @since 2022-05-24
  */
  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);
  }
  }

————————————————
版权声明：本文为CSDN博主「我是有多懒」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/beibei3321/article/details/124943299