TIME

MONDLOC

New Member
Joined
Jan 23, 2004
Messages
4
I am inputting a lot of miltary time cells. Is there a way that i can set it up so that the colon will automatically appear when I enter the four digits? Thanks
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,119,085
Messages
5,576,027
Members
412,694
Latest member
Deaf1Too
Top