Converting Standard Time to Military Time in Excel

M

mtvschultz

What function can be used to convert a column of Standard Time to a column of
Military Time in Excel?
Is it a formula or formatting?
 
G

Gord Dibben

What do you consider as Military Time format?

If 13:30 then use formatting under Number>Time

If 1330 there is no default Excel format for this.

Custom format to hmm;@

Note: the time will still be AM or PM in the formula bar.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert string to military time string 14
Microsoft Office Standard 2013 0
Converting Standard Time into Military Time 3
Military time 5
formula help 3
Convert time to military time? 3
Cumulative formula for word table 0
Entering a time into excel 10

Top