converting to recognizable time format

[Daflinders]

I am trying to use datetime to convert a series of numbers in to a recognizable time. It only catches about half the values. Here is why.

currently my data is just a string of numbers. For example 10:23 and 5 seconds is 102305.

However, if the hour is between 1am and 9am it won't recognize it because it stores it with 5 number instead of 6.

so if the string only has 5 characters i need it to add a 0 at the beginning.

Here is a data set:

202803
203159
220526
221029
234453
12325
63720
82209
82209
121731
143049

[ggruccio · Accepted solution]

Hi @Daflinders,

To accomplish this, you'll need to convert your data to a string using a Select Tool - then use the Formula Tool to check the length of the field.  If it is 5 then add a "0" to the front of the data, else keep the same....

Formula language shown below: