convert string to time

[ericb123]

I cannot seem to get this correct: Using CR11, I have a string which is military time, formatted as HHMMSS:

135819

How can I convert this to a time, then convert it from military time to 12hour time? I've tried the Ctime function, and the Istime func, but it doesn't work.

The IsTime func. returns true when the time happens to fall within the 1-12 hours, then false for anything above 12.

Any help is greatly appreciated, thanks!

 

[lbass]

Use a formula like this:

stringvar x := {table.string};
time(val(left(x,2)),val(mid(x,3,2)),val(right(x,2)))

You can then format this however you like.

-LB

 

[ericb123]

awesome, thanks!