如何在excel里计算出相隔的工作小时,公司上班时间:08:00-12:00,13:3...答:如果起始时间放放在A1单元格,结束时间放在B1单元格,则公式为:=(ROUNDUP(B1-A1,0)-ROUNDDOWN((WEEKDAY(A1)+ROUNDUP(B1-A1,0))/7,0))*8+IF(WEEKDAY(A1)=7,0,IF(MOD(A1,1)<TIME(8,0,0),8,IF(MOD(A1,1)<TIME(12,0,0),8-(MOD(A1,1)-TIME(8,0,0))*24,IF(MOD(A1,1)<...