Excel 计算到期时间

=TEXT(A1-NOW(),"[H]"&"小时"&"MM"&"分钟"&"SS"&"秒") 如果只求 小时：=TEXT(A1-NOW(),"[H]"&"小时") 分钟：=TEXT(A1-NOW(),"MM"&"分") 秒：=TEXT(A1-NOW(),"SS"&"秒")