Format time questions,

[dainova]

Hi,
I want make Time column entry as easy as possible, I selected Format as TIME: 15:00. It works, but if I want to enter just hour without colon, it all defaulted to zero 0:00:
eg.
Type 15 ===> 0:00 , but expected 15:00
Type 15:3 ===> 15:03, expected 15:30

Is there any way to solve this magic and still be in time format? It's office 07.

I also plan to put this on Google docs.

Thansk to all
Dai

[vlady]

hello Dai

don't now if this can help you..

cell formatting to be used 00\:00
you should enter 1500 to get 15:00
for 15 only you'll get 00:15
for 1256 you'll get 12:56
for 2450 you'll get 2:45