热心网友
回答时间:2024-04-20 12:59
以小数表示:
=TEXT(SUBSTITUTE(C2,".","",1),"0-00-00 00\:00\:00.000")-TEXT(SUBSTITUTE(B2,".","",1),"0-00-00 00\:00\:00.000")&"天"
以天小时分秒毫秒表示:
=INT(TEXT(SUBSTITUTE(C2,".","",1),"0-00-00 00\:00\:00.000")-TEXT(SUBSTITUTE(B2,".","",1),"0-00-00 00\:00\:00.000"))&"天"&TEXT(TEXT(SUBSTITUTE(C2,".","",1),"0-00-00 00\:00\:00.000")-TEXT(SUBSTITUTE(B2,".","",1),"0-00-00 00\:00\:00.000"),"h小时m分s.000秒")
收起