假设A2单元格是起始时间,B2是结束时间.在其他如C2单元格写下公式:
1、时:分:秒格式(不计算天数): =TIME(HOUR(B2-A2),MINUTE(B2-A2),SECOND(B2-A2))
2、天时分秒格式: =CONCATENATE(DATEDIF(A2,B2,"d"),"天",HOUR(B2-A2),"时",MINUTE(B2-A2),"分",SECOND(B2-A2),"秒")
3、时分秒格式(将天数转换成小时): =CONCATENATE(DATEDIF(A2,B2,"d")*24+HOUR(B2-A2),"时",MINUTE(B2-A2),"分",SECOND(B2-A2),"秒")
4、全都换算成秒: =DATEDIF(A2,B2,"d")*24*3600+HOUR(B2-A2)*3600+MINUTE(B2-A2)*60+SECOND(B2-A2)
追问像图中格式‘月/日/年’的,有没有办法批量更改成‘年/月/日’的格式
追答没有,要换算的。
追问![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbff557843a15d8bc3eb03541c2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
C2单元格计算错误是怎么回事