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

Converting Standard Time into Military Time 3
Military time 4
military time 2
MEAN in Military Time 4
formula help 3
Entering a time into excel 10
Time sheet template military hours problem 6
formula for converting military time to standard time, etc 8

Top