Posted to microsoft.public.excel.misc

awais

external usenet poster

Posts: 5

military format of time

how can i feed time in military format? e.g. 1210 for 12:10 PM, 1740 for
17:40 PM, 0030 for 12:30 AM.

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
i want to use military format for time e.g. 07:00 as 0700	awais	Excel Worksheet Functions	2	May 18th 08 04:48 PM
Military Time Conditional Format	stevieboy1313	Excel Discussion (Misc queries)	17	August 15th 07 02:21 PM
Format cell as military time	Mike	Excel Discussion (Misc queries)	10	July 18th 06 07:12 PM
getting military time format within excel	dgarrison	Excel Discussion (Misc queries)	3	December 25th 05 10:47 PM
adding military time format	am6160	Excel Discussion (Misc queries)	2	December 28th 04 08:41 PM

All times are GMT +1. The time now is 05:11 PM.

About Us

"It's about Microsoft Excel"