I have a spreadsheet where I am just entering times such as 1620 or 0945 etc. My question is: How can I enter the time such as 1620 and have it appear as 16:30 or 09:45. I would like to have the colon automatically insert between the four digits of time without having to type in the colon. Can this be done?