Hi,

Maybe your cell was formatted as text before you entered the date/time.
Format as General and try again.

Mike

"Devan" wrote:

How can I get the result of an enterd number in a cell as time in HH:MM
format. I selected the custom format hh:mm; but it shows the date too in the
cell and the number which I given in the cell is refered as date.