Time conversion

[Mike]

Looking for a way to convert time (9:00 PM) to military
time (2100)

Any suggestions appreciated

Thanks in Advance

Mike

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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.