excel 通过时间计算工作天数?答:公式为:=LEFT(B1,FIND(",",B1)-1)-LEFT(A1,FIND(",",A1)-1)+CEILING((MID(B1,FIND(",",B1)+1,9)-MID(A1,FIND(",",A1)+1,9))*3,0.5)
excel 2020.10.03 09:52:48 - 2020.10.03 15:59:06 这样一串数字怎么用...答:假如数据在A列并从A1开始,在B1单元格输入公式=TEXT(RIGHT(SUBSTITUTE(A1,".","/"),19)-LEFT(SUBSTITUTE(A1,".","/"),19),"hh:mm:ss")或 =TEXT(RIGHT(SUBSTITUTE(A1,".","/"),19)-LEFT(SUBSTITUTE(A1,".","/"),19),"h小时m分s秒")如图:...