Convert numbers to time format

[kras]

Hi,

I've just would like to convert numbers to time format. For example, if I type 164523 I would like it to be displayed in the cell as 16:45:23.

Thank you.

kras

[VBA Noob]

This link might help

http://www.cpearson.com/excel/DateTimeEntry.htm

VBA Noob

[kras]

Hi Noob,

Thanks for the reply. I didn't know that it was supposed to be related with coding.

kras

[VBA Noob]

You can use a helper column

=LEFT(A1, 2) & ":" & MID(A1, 3, 2) & ":" & RIGHT(A1, 2)

VBA Noob

[kras]

Thanks again.