How to convert time string to timestamp in 24 hour format?

[ashu1702]

Hi 

Suppose the time zone is in string format like 100403, need to convert this in 24 hour format. Output should be like 22:04:03. 

[VatsalJagani]

@ashu1702 - How in this example would you identify whether it's AM or PM?

It seems like here you are assuming it's PM and that's why conversion says 22:04:03.

[ashu1702]

Hi @VatsalJagani 

Yes, Vatsal it's in PM.

What would be the solution in both case i.e if AM or PM.

 Can you help me with that?

[VatsalJagani]

@ashu1702  - But if you give a proper string that has a full value that includes AM/PM then I can give you the right eval statement that you can use.