Excel: not time, but duration

williamwclee

例如：2:15
點樣令 excel 知道呢個係 duration，不是時間  2時15分 AM
因爲處理時間，輸入欄會顯示 AM/PM，如果處理時段，就不應該顯示 AM/PM

SleepyPrince

個底都係用時間儲存
對 Excel 嚟講兩樣嘢其實一樣, 計算方法亦一樣
只可以用格式 hh:mm 令佢唔顥示 AM/PM

williamwclee

回覆 2# SleepyPrince

頂端輸入欄一樣顯示 am/pm，儲存格就冇顯示。
儲存格 2:30 輸入欄就顯示 2:30 AM
儲存格 14:30 輸入欄就顯示 2:30 PM

SleepyPrince

用咗自訂格式顥示都有 AM/PM？

javacomhk

Highlight the cell(s)/column which you want as Duration, right click on the mouse to "Format Cells". Go to "Custom" and look for "h:mm" if you want to input duration in hour and minutes format. If you want to include seconds as well, click on "h:mm:ss". You can even add up the total duration after that.

Extra

如果「小時」的數值有機會大過 24，試試加上括號，如下：
[hh]:mm 或 [h]:mm

williamwclee

回覆 5# javacomhk

講緊 頂段 輸入欄，not cell display

SleepyPrince

如果你在意頂段輸入欄
咁唯有直接改 Windows 顥示時間個格式, 用24小時制

狂蜂一號

"You can even add up the total duration after that." -- 咁樣頂端輸入欄都仲有 AM/PM？

jimie

Try 120 mins