Is there a way to be able to type it in a number (i.e. 11.45) and have it
display as a time (11:45)? When I format the cell to display as time I have
to type the hour, a colon, and minutes. Is there any way around this?