Converting Standard Time to Military Time in Excel

  • Thread starter Thread starter mtvschultz
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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 2
Military time 4
Convert Time 3
Excel time conversion issue 4
convert text to date 2
MEAN in Military Time 4
Time sheet template military hours problem 6

Back
Top