convert a number to time

R

rbus

Hello everybody !!

Do you any idea for my problem ?
I've a column with times : HHMMSS
145204 == 2PM 52 min 04 sec
130298
000159
How to easily format this column as time format : 14:52:04 for example ?
Thank you for your help !!
rb
 
J

JE McGimpsey

One way:

If you just want to display the number as a time:


Format/Cells/Number/Custom 00\:00\:00

If you actually want to convert the number to a time:

B1: =--TEXT(A1,"00\:00\:00")

To convert the number into a time in-place will require a macro.
 
Top