在现在的时间上加七个小时
A B C D
20141115 9:12 20141115 16:12
20141116 23:10 20141116 6:10
1 2 | =IF(B1>D1,A1+DATE(0,0,1),A1) =B1+TIME(7,0,0) |
在现在的时间上加七个小时
A B C D
20141115 9:12 20141115 16:12
20141116 23:10 20141116 6:10
1 2 | =IF(B1>D1,A1+DATE(0,0,1),A1) =B1+TIME(7,0,0) |