How to get timein hh:mm format

[Devan]

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.

 

[Mike H]

Hi,

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

Mike

 

[Bob Phillips]

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

 

[Jacob Skaria]

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