entering military time

[Gadgetman]

Is there a way to enter military time by just using the 4 digits and
not having to use the colon ) between hours and minutes? For
instance, is there a wy to enter 1315 and have excel still recognize it
as a time in military time?

 

[JE McGimpsey]

Is there a way to enter military time by just using the 4 digits and
not having to use the colon ) between hours and minutes? For
instance, is there a wy to enter 1315 and have excel still recognize it
as a time in military time?

See Chip Pearson's method:

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