補充發問- Excel問題? 如何時間每15分鐘累加

💻 軟件台程式編寫及設計

[匿名]

2007-12-14 6:21 am

已按以下公式解決了, 但對其原理就想極都唔明, 能否詳細解答呢?
再次勞煩你了!! 謝!

響A2嗰格設定公式：　=A1+(1/24/60*15)　
原理係：A1 + 15分鐘，而每1日有24個鐘，每個鐘有60分鐘，你想加15分鐘，咁即係將8:00加上1(日)／24(小時)／60(分鐘)ｘ15（分鐘
然後將A2照copy去A3．．．．即可

更新1:

**Sorry, I really don't understand, as per your formula :- 1/24 = 0.04166..../60 =6.9444...x 15 = 0.01042 How comes to 15 mins ? Please help me ! Best regards, Stupid guy

回答 (2)

Philip

2007-12-14 9:31 am

✔ 最佳答案

Because if you type =A1+1 in A2 , +1 means add 1 day.

So if you want to add 15 minutes .

You will need to represent that in minutes if you just want to add 15 minutes , therefore:

[1day/24 hours / 60 min ] * 15 = 15 minutes.

I hope that helps.

參考: myself

👍 0 👎 0

Andy Chan

2007-12-20 11:07 pm

1 日 = 1
1 小時 = 1/24 = 0.04167
60 分鐘 = 0.04167
1 分鐘 = 0.04167/60 = 0.000694
15 分鐘 = 0.000694*15 = 0.010417

👍 0 👎 0

收錄日期: 2021-04-19 22:53:26
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071213000051KK04043

檢視 Wayback Machine 備份