Hello all,

I need help please in the attached file.. it's an output of attendance application that returns login time as text without space between numbers and AM or PM ..
I need a formula or function that can returns me the time in 24hrs formate from that text.
please find the attached file .. timing.xlsx

Waiting for your response asap.

Regards,
Ahmed Kandil