How to Use a custom format to create a time format
When you enter time values in cells, you have to type the colon between the hours and minutes. However, this is unnecessary if you use a custom format.
How to create a customized time format:
- Enter time values without colons and select the cells.
- From the Format menu, select Cells.
- Select the Number tab and click on Custom under Category.
- Type 00″:”00 as the custom format.
- Click OK.
You can also use the AutoCorrect options. From the Tools menu, choose AutoCorrect and then the AutoCorrect tab. Type two commas in the Replace field and type the colon in the With field. Click Add to insert this option. Test this by typing 1200 in a cell. Excel corrects the input to 12:00.
