EXcel日期时间相减,剔除夜间,夜间为23:00-6:00,a1为2011-2-13 7:30...答:=(B1-A1)*24-7*DAYS360(A1,B1)格式改成数字 --- =(IF(AND(HOUR(B1)>6,HOUR(B1)<23),B1,DATE(YEAR(B1),MONTH(B1),DAY(B1))+TIME(23,0,0))-IF(AND(HOUR(A1)>6,HOUR(A1)<23),A1,DATE(YEAR(A1),MONTH(A1),DAY(A1))+TIME(23,0,0)))*24-7*DAYS360(IF(AND(HOUR(A1)>...