请问在excel里,怎样设置时间差公式计算工时?比如10:36上班 第二天凌晨...答:假定上班时间在B列,下班时间在C列,工时在D列,D1公式如下:=INT((C1+(C1<B1)-B1)*24)+LOOKUP(MOD((C1+(C1<B1)-B1)*1440,60),{0,15,45},{0,0.5,1})-(B1<TIME(12,0,0))
...一串数字怎么用excel函数、公式等等计算出时间差?答:假如数据在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秒")如图:...