例如: 3:00pm - 12:00pm = 4 hours
唔該一步步講....
點樣用excel計時間??
2007-12-22 6:10 am
回答 (1)
2007-12-23 12:09 am
✔ 最佳答案
3:00pm - 12:00pm = 4 hours ??? 應該是 3 hours儲存格輸入 1 等於 1 日, 故此 3:00PM = 15:00 = 15/24 日 = 0.625 日
因此, 時間相減後要 乘以 24 化回 小時
設 A1 = 3:00 pm
B1 = 12:00pm
C1= (A1-B1)*24
= 3
2007-12-22 17:00:56 補充：
或者C1 = A1 -B1但,要改儲存格的格式格式 > 儲存格 > 自訂 > 類型 > h:mm
收錄日期: 2021-04-27 13:12:22
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071221000051KK03581