Military Time Data Entry

L

L. Roper

In Exce 2002, is there any way to format a cell so that you can type 1345 and
have it appear as military time 13:45?

Thank you for your help.
 
M

Mike Mueller

That would be best answered in an Excel newsgroup, this one
is for frontpage.
-out of the box you can set the format for the cell to the
24 hour clock, but that will not perform as you want.


message
: In Exce 2002, is there any way to format a cell so that
you can type 1345 and
: have it appear as military time 13:45?
:
: Thank you for your help.
 
Top