急問有關excel 時差計算方法

Assume in Cell A1 you have [23:00] and cell B1 you have [17:00],

in cell C1,you can just simply put =A1-B1

you will see 6:00, which means 6 hours difference.


Assume in Cell A2 you have [23:15] and cell B2 you have [17:00]

in cell C2, you can simply put =A2-B2

you will see 6:15, which means the difference is 6 hours and 15 minutes.



See whether that helps

有分鐘, 甚至有秒都可以
A1 = 23:15
B1 = 17:00
公式: =TEXT((A1-B1)*24,"#0.00")→6.25
以上公式是固定小數後兩個位

請問Excel入面, 有無formula可以計算到兩個時間的差距?

e.g. 23:00 減 17:00 (formula計出"6")?

如果兩個時間是有分鐘的, 可否有formula計算到?

e.g. 23:15 減 17:00 (formula計出6.25)?

請各位幫忙~THANK~