B Barb Reinhardt Dec 25, 2005 #2 Sure there is. Use FORMAT -> CELLS -> TIME and select the military time format you want.
N Niek Otten Dec 25, 2005 #3 You can Custom format a cell as hhmm, so it will show 2250. However, you still cannot enter it as 2250; you'll have to enter 22:50 If you want to avoid that, see http://www.cpearson.com/excel/DateTimeEntry.htm
You can Custom format a cell as hhmm, so it will show 2250. However, you still cannot enter it as 2250; you'll have to enter 22:50 If you want to avoid that, see http://www.cpearson.com/excel/DateTimeEntry.htm
R Ragdyer Dec 25, 2005 #4 If you're not looking to use code, an old trick is to use "AutoCorrect". <Tools> <AutoCorrect> In "Replace", enter " .. " (2 periods / decimals) - (no quotes), In the "With" box, enter the colon " : " (no quotes). You'll find that this is extremely easy for entering times, especially if you're versed in ten key.
If you're not looking to use code, an old trick is to use "AutoCorrect". <Tools> <AutoCorrect> In "Replace", enter " .. " (2 periods / decimals) - (no quotes), In the "With" box, enter the colon " : " (no quotes). You'll find that this is extremely easy for entering times, especially if you're versed in ten key.
