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.

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.

You need to enter the value in the format hh:mm as well.

--
__________________________________
HTH

Bob

"Devan" wrote in message
...
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.

Format Cells--Time should work.

If not try; assuming you have your data in A1

=TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

The below will format the value to text
=TEXT(A1,"hh:mm")

If this post helps click Yes
---------------
Jacob Skaria


"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.