請問EXCEL問題，如照片所示， ｃ列表格中會有天與ｈ表示，若該員無資料則不顯示，超過８ｈ算１天，C41=C38+C39-C40，不知道如何改此公式？
回答 (2)
2017-06-01 11:57 am
2017-06-05 10:04 am
試試看這個
=TEXT(EVALUATE(SUBSTITUTE(SUBSTITUTE(B1&"+"&B2&"-("&B3&"+0)","天","+"),"H","/8")),"dd天")
=TEXT(EVALUATE(SUBSTITUTE(SUBSTITUTE(B1&"+"&B2&"-("&B3&"+0)","天","+"),"H","/8")),"dd天")
收錄日期: 2021-05-04 02:11:22
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170601004646AAk8lUR