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 [...]
