標題:
補充發問- Excel問題? 如何時間每15分鐘累加
發問:
已按以下公式解決了, 但對其原理就想極都唔明, 能否詳細解答呢? 再次勞煩你了!! 謝! 響A2嗰格設定公式：=A1+(1/24/60*15) 原理係：A1 + 15分鐘，而每1日有24個鐘，每個鐘有60分鐘，你想加15分鐘，咁即係將8:00加上1(日)／24(小時)／60(分鐘)ｘ15（分鐘 然後將A2照copy去A3．．．．即可 更新: **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
最佳解答:
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.
其他解答:
此文章來自奇摩知識+如有不便請留言告知
1 日 = 1 1 小時 = 1/24 = 0.04167 60 分鐘 = 0.04167 1 分鐘 = 0.04167/60 = 0.000694 15 分鐘 = 0.000694*15 = 0.010417
留言列表
