Do you just mean 24 hour format then that is the default format of Excel and
you can change the default settings in windows control panel under regional
settings or just use hh:mm as opposed to hh:mm AM/PM So if you have 12:00 AM
in a cell and convert it to 24 hour format it will be displayed as 00:00
which is what it is, you seem to want 24:00 which you will get if you type
in 1 (one day is 24 hours) and use a custom format of [hh]:mm
however military time is when you write (and presumably say) 08:00 AM as 800
or 08:00 PM as 2000 (I believe they say Twenty Hundred) then there is no
built in format for this
You need to use either formulas or macros
--
Regards,
Peo Sjoblom
Titanium said:
I am trying to convert a number of cells to the military format. However,
when I try to accomplish this using Format -> Time -> "Military format
type"
the result is 0:00:00.
I would certainly appreciate any help on this. Thank you in advance.