=IF(QUOTIENT(((B2-NOW())*24*60*60),24*60*60)>0,QUOTIENT(((B2-NOW())*24*60*60),24*60*60)&"天","")&IF(QUOTIENT(((B2-NOW())*24*60*60),60*60)>0,QUOTIENT(MOD((B2-NOW())*24*60*60,24*60*60),60*60)&"小时","")&IF(OR(QUOTIENT(MOD(MOD((B2-NOW())*24*60*60,24*60*60),60*60),60)<0,INT((B2-NOW())*24*60*60)>0),QUOTIENT(MOD(MOD((B2-NOW())*24*60*60,24*60*60),60*60),60)&"分钟","")&IF(INT((B2-NOW())*24*60*60)>0,INT(MOD(MOD(MOD((B2-NOW())*24*60*60,24*60*60),60*60),60))&"秒","0秒")
结束时间至现在时间的倒计时
追答C2输入:
=DATEDIF(NOW(),B1,"d")&" "&TEXT(B1-NOW(),"hh:mm:ss")
注意:如果你不刷新页面,时间是不会自动计算的。