» Entering Times Quickly

Problem:

Entering times quickly, without having to use a colon to separate hours and minutes.

Solution:

Use the TIMEVALUE, IF, LEFT, and RIGHT functions as shown in the following formula:
=TIMEVALUE(IF(A2<1000, LEFT(A2,1),LEFT(A2,2))&":"&RIGHT(A2,2))
Enter the above formula in column B and format the cells as "hh:mm".
The formula will convert each numerical value in column A to a properly formatted time value.