Convert Time Format

The given time format in excel is 6:15PM.
I want to convert the above timestamp to 24-hr format i.e. 18:15PM


If you are using an excel loop then you will get a string. You can parse the string and do the conversion accordingly.

If you are using Advanced Loop Excel then using Date Time function you can convert given time to 24 hr format

Amit Anand