Just to add:
You still need to enter time with a colon.

21:00 or 9:00 PM for example. It will then display without the colon in
your definition of military time. Using the colon for entry tells excel
that it is a time value.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
if this is data entered in cells as a time value, the all you need to do
is
select the cell and do

Format=Cells
go to the number tab, select custom and then enter a custom format like

hhmm

--
Regards,
Tom Ogilvy



"Mike" wrote in message
...
Looking for a way to convert time (9:00 PM) to military
time (2100)

Any suggestions appreciated

Thanks in Advance

Mike