Excel中日期与数字的转换代码

最新推荐文章于 2025-03-04 14:40:27 发布

一只小蚂蚁吆

最新推荐文章于 2025-03-04 14:40:27 发布

阅读量625

点赞数

分类专栏： java开发文章标签： java

java开发专栏收录该内容

61 篇文章

订阅专栏

    public static void main(String[] args) {
        int days = 41829;
        double ditNumber = 0.4330324074;
        Date date = getDate(days);
        Date dateTime = getTime(date, ditNumber);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        System.out.println(sdf.format(dateTime));
    }
    
    public static Date getDate(int days) {
        Calendar c = Calendar.getInstance();
        c.set(1900, 0, 1);
        c.add(Calendar.DATE, days - 2);
        return c.getTime();
    }
    
    public static Date getTime(Date date, double ditNumber) {
        Calendar c = Calendar.getInstance();
        int mills = (int) (Math.round(ditNumber * 24 * 3600));
        int hour = mills / 3600;
        int minute = (mills - hour * 3600) / 60;
        int second = mills - hour * 3600 - minute * 60;
        c.setTime(date);
        c.set(Calendar.HOUR_OF_DAY, hour);
        c.set(Calendar.MINUTE, minute);
        c.set(Calendar.SECOND, second);
        return c.getTime();
    }