Hello from Steved

The objective is to Convert 1:05pm to 1305 please in the same Column.

I do not know enough experience to wright the macro to have the below working
Please help me.

Cells(SomeRow, SomeColumn).Value = Format(Cells(2, "C").Value,"hhmm")

Thankyou.