I'm trying to take just one cell and set it up to display a time. it someone
entered 330 I need the cell to display 3:30. When no time is entered in it
can display 0:00 for the time. I have tried clicking on time in the number
drop down. It shows 0:00 then I type in 930. when I hit enter it returns
0:00. If I click on the ceel it displays a date and time. All I want in the
cell is the time to show if it is entered 930. Can any one help me.