The given time format in excel is 6:15PM.
I want to convert the above timestamp to 24-hr format i.e. 18:15PM
Hi,
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
Regards,
Amit Anand