2023-08-02 07:36
在D2单元格做团输入公式:
=TEXT(INT(B2-A2),"0天;;")&TEXT(MOD(B2-A2,1),"纯胡敏做枝0.00小时;;")
或者是公式:
=TEXT(B2-A2,"[D]天HH小时MM分钟")
=TEXT(B2-A2,"[D]天H小时")
复制并下拉,即可…………
=TEXT(A1-B1,"d天h小谈陆时m分陵侍隐尺厅")