How to get timein hh:mm format

  • Thread starter Thread starter Devan
  • Start date Start date
D

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.
 
Hi,

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

Mike
 
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
 
Back
Top