1、首先,计算两个日期之间的天数。在excel中,直接减去两个日期以获得两个日期间隔的天数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b74594289a71c1fc1e178a82151c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、计算两个日期之间的天数,也可以用隐藏函数DATEDIF函数来完成
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f413419d728192b1f95cad0c85ef0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、函数语法是这样的:= DATEDIF(开始日期,结束日期,第三个参数),第三个参数可以有几种情况,分别可以返回天数,月数和年数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a60590f9ccc7d2634349b023bbacc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、最简单的是两个时间直接相减即可得到时间差。但是注意,存储结果的单元格要设置成时间格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6f061d950a7b0208874512866cd9f2d3562cc8cd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、设置单元格格式为“[h]:mm:ss”,其中h加上方括号可以将时间的差小时数完全显示,如果不加方括号只能显示扣除天以后的小时之差。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d3719a5963990a304e251f5818?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)