=LEFT(A1,IF(A1<100000,1,2))&":"&MID(A1,IF(A1<10000 0,2,3),2)
&":"&RIGHT(A1,2)
If you put all that inside of =value() it will convert to
to the excel time code, but unless you are using military
time these will all be AM.
-----Original Message-----
Hello experts.
I have data as follows:
94423
94717
100523
101142
Is there a formula I could apply to change the numbers to
time:
9:44:23
9:47:17
10:05:23
10:11:42
Thank you so much for your help.
--
MB
.
|