LHaro

Posts: n/a

formating military time

Hello,

I am trying to format military time in excel to display regular times
(without displaying the AM/PM). For Example, I have a cell that contains
1:00:00 PM, it is displayed as 13:00, but i want it to display 1:00. Any
help on this would be greatly appreciated.

Many Thanks

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	Sue	Excel Worksheet Functions	2	May 2nd 05 05:45 PM
DOS Data in Excel Format with Date and Military Time in same cell	Jules	Excel Worksheet Functions	1	March 14th 05 09:31 PM
in excel totaling weekly hours military time	mel	Excel Worksheet Functions	1	January 17th 05 04:24 PM
How do I convert Military Time to minutes?	Rachael	Excel Worksheet Functions	1	January 6th 05 10:01 PM
how do you subtract military time? example 12:00 - 07:00 = 5 hour.	Bill	Excel Worksheet Functions	1	October 27th 04 08:25 PM

All times are GMT +1. The time now is 06:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us