Convert numbers to time format

**kras** · 04-15-2007, 02:42 AM

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** · 04-15-2007, 04:32 AM

This link might help

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

VBA Noob

**kras** · 04-15-2007, 04:42 AM

Hi Noob,

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

kras

**VBA Noob** · 04-15-2007, 04:46 AM

You can use a helper column

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

VBA Noob

**kras** · 04-15-2007, 04:54 AM

Thanks again.

Convert numbers to time format

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Convert numbers to time format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions