Posted to microsoft.public.excel.misc

L. Roper

external usenet poster

Posts: 2

Military Time Data Entry

In Exce 2002, is there any way to format a cell so that you can type 1345 and
have it appear as military time 13:45?

Thank you for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Military time...	NWO	Excel Discussion (Misc queries)	3	March 24th 07 06:29 PM
How to keep 0 for military time	Tory	Excel Discussion (Misc queries)	2	September 5th 06 08:29 AM
Convert data into standard military time format	geog	Excel Discussion (Misc queries)	2	December 12th 05 07:46 PM
Show timesheet time in and out in regular time versus military tim	John	Excel Worksheet Functions	1	November 11th 05 05:14 AM
DOS Data in Excel Format with Date and Military Time in same cell	Jules	Excel Worksheet Functions	1	March 14th 05 09:31 PM

All times are GMT +1. The time now is 07:19 AM.

About Us

"It's about Microsoft Excel"