Dear All, I have colom "Date & Time". But I cant change time as what i need. Example. 12.01am. Its onluy aloow for every 5min. How can i change it?. Regards Lasantha

Hi, You should create calculated column and use the below formula. =TEXT(Created,"HH:MM:SS") Hope this will help Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

Thanks Hemendra. Let me explain better. The Date and Time type only allows to change the minutes 5 in 5. So I can not choose 13:04; I have to choose 13:00 or 13:05. Do you know if it is possible to change this default to be able to choose any minute? Thanks Regards, Lasantha

Edit the column in a datasheet view and you should be able to enter the time with the exact minute. -Brian