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
 
Top