更新1:
謝謝解答，我可能沒有表達清楚我要的答案，我是要將此算法設成EXCEL的公式，因為我將近有10000筆的資料須要計算，再請大家幫忙，謝謝！
題目：急件~~時間相減求共相差幾小時幾分 (A1) 01/01/2015 07:51:07 (B1) 01/01/2015 17:24:59 想請大家幫忙解答 C1表格要求出(B1)-(A1)總共過了幾個小時？再請大家幫忙，謝謝大家！?
回答 (2)
2015-12-12 5:22 am
✔ 最佳答案
.C1:
=TEXT(B1-A1,"[h]:mm")
向下複製公式
2015-12-10 9:49 am
C1 = B1- A1
= 01/01/2015 07:51:07 - 01/01/2015 17:24:59
= 17:24:59 - 07:51:07
= 10:24:52 - 0:51:00
= 9:84:52 - 0:51:00
= 9:33:52 - 0:00:00
= 9 + 33/60 + 52/3600
= 9 + 11/20 + 13/900
= 9 + (990 + 26)/1800
= 9 + 1016/1800
= 9 + 254/450 hours
= 9.56444444... hours
= Answer
= 01/01/2015 07:51:07 - 01/01/2015 17:24:59
= 17:24:59 - 07:51:07
= 10:24:52 - 0:51:00
= 9:84:52 - 0:51:00
= 9:33:52 - 0:00:00
= 9 + 33/60 + 52/3600
= 9 + 11/20 + 13/900
= 9 + (990 + 26)/1800
= 9 + 1016/1800
= 9 + 254/450 hours
= 9.56444444... hours
= Answer
收錄日期: 2021-04-30 20:01:11
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20151209232746AAPdRtQ