Dear experts,
I have an excel report generated by the system. All timings on the sheet is stored as text. I need to perform calculations with these values and need a macro to convert the text from 5:00 to 05:00.
Attached is a system generated excel report.
Thank You.