Military Time Data Entry

[Guest]

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.

 

[Guest]

Highlight the cells you want this format on... go to

Formate---> Cells---- > Number

Then select Custom

In the Custom menu type

##":"##

Then Press Enter

 

[Guest]

I think I might have accidently replied to this question to a different
person... if not this will be the same answer as the previous post... but if
not

Select all the cells you want that format to show up as

Go to Format----> Cells----> Number

Select Custom from the list
In the Custom field type

##":"##

Then press enter.

 

[Guest]

Check this out.

http://www.cpearson.com/excel/DateTimeEntry.htm

 

[Gord Dibben]

AKphidelt

The operative word being "appear".

Your suggested custom format will not actually produce a valid time.

You need VBA code for that.

See Richard's response with the link to Chip's site.


Gord Dibben MS Excel MVP